Thank you very much for the prompt reply Sir.
- Original Message -
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Monday, February 14, 2011 8:17 PM
Subject: Re: $$Excel-Macros$$ Nos. of Sundays between two days
start date in a1
and end date in a2
no of
The biggest confusion here is the difference between
the Worksheet OBJECT: Sheet1
the Worksheet NAME: Sheet1
and Sheets ARRAY: Sheets(1)
An Excel workbook must contain at least one sheet.
Excel will INTERNALLY Identify this sheet object as Sheet1
and will initially NAME the sheet Sheet1
Sub test()
UserForm1.Image1.Picture = LoadPicture(D:\koul\krishna.jpg)
UserForm1.Show
End Sub
On Tue, Feb 15, 2011 at 11:55 AM, San Pat myitems2...@gmail.com wrote:
How I can load a image from a url using the LoadPicture function in
userform.
Regards,
--
I have written a sub routine to add a name to a dynamic list but I
have three problems with it and would be grateful for some advice.
First the routine:-
Sub InputNewUser()
'
' InputNewUser Macro
' Macro recorded 01/02/2011 by Brian
'
Dim Newuser As String
Dim nextRow As Long
Dim flag As
Respected Sir,
I have many 500 rows in my excel sheet
i want sort all row ascending order.
for exp
1 row 102 103 105 110 120
2 row 103 102 110 105 120
how i convert it into
1 row 102 103 105 110 120
2 row 102 103 105 110 120
--
try this
Sub Macro1()
Dim i As Long
For i = 1 To Sheets(1).Range(a1).End(xlDown).Row
ActiveWorkbook.Worksheets(Sheet1).Sort.SortFields.Clear
Worksheets(Sheet1).Sort.SortFields.Add Key:=Range(b i :i i),
_
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
Thanks *Ashish *for reply but can you please provide formula without pivot.
Condition you have understand that if sum of any classification is grater
then others,it shows that value.
On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.com wrote:
On Tue, Feb 15, 2011 at 12:16 AM,
will it be these three classifications only
On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Thanks *Ashish *for reply but can you please provide formula without
pivot. Condition you have understand that if sum of any classification is
grater then others,it shows
VLOOKUP(IF(VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)=
1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)-1440,VLOOKUP(J4,$A$19:$B$50,2,0)+VLOOKUP(J5,$C$19:$D$31,2,0)+VLOOKUP(J6,$E$20:$G$44,3,1)),$A$2:$C$15,3,1)
On
hi please use this simple procedure
Excel Text to Column Command
The Text to Column command allows you to break text in one column into
several columns. For example, if you have LastName, FirstName in a column,
you can break the text into two columns—one containing LastName and the
other
Dear Excel Gurus,
I know mailmerge but how to do the same thing in excel, I also know that It
is very easily done using Ms-access. how to do mailmerge in excel.
because we want the desired data in excel only
Regards
Jitender
-- Forwarded message --
From: Sanjoy Nath
Thanks for your thorough explanation Paul. I now understand that
sheets() points to the position of the sheet in the file. I still do
not understand how to use the sheet.name though.
This is what I have in objext explorer
sheet1 (Process) 'is the first sheet
sheet2 (Hours) ' is 3rd sheet
sheet3
I am using a web url.
Is there anyway I can covert/save web url in picture format and then call it
in the below function?
Regards,
San
On Tue, Feb 15, 2011 at 5:46 AM, ashish koul koul.ash...@gmail.com wrote:
Sub test()
UserForm1.Image1.Picture = LoadPicture(D:\koul\krishna.jpg)
what exactly you are looking for .. do you want us to transfer data into
the site from excel sheet
On Tue, Feb 15, 2011 at 6:46 AM, Rajasekhar Praharaju
rajasekhar.prahar...@gmail.com wrote:
hi ,
Please help in this concern can any one help in this concern i require this
computation using
The choice of which approch to use is really a question of Readability and
Functionality.
You can use:
Sheet1.Select
Sheet2.Select
Sheet3.Select
as long as you know you're not going to be deleting and adding sheets.
Once you delete a sheet, even if you make a copy and delete the original, this
Say for example I have one tab that has a list of contact information
- say anywhere from 1000 to over 100,000 contact items that include
name (one field for first and last name), phone, address, etc.
On the other tab I have a list of Categories. 1 column for Category
Name and the other for a
I have solved the cancel button exit from the routine problem part 1
as follows:-
'Check to see if cancel button is pressed go back to Menu
If Newuser = false Then
Sheets(Menu).Select
Exit Sub
End If
Still cannot get anything on the other two problems
Brian
Scotland
On
Dear Vinod,
The sum formula is giving correct solution if you mean by 0:20 mins. Kindly
explain where are you facing the issue or why do you think the sum for 4:30
is not correct.
--
Best Regards!
Prakash Singh Gusain
*Please visit my blog (**click here http://prakashgusain.blogspot.com/**)*
I am struggling with this and wondering if you could help..
Worksheet 1 Column A B
Keyword Category
telecom Telecom
tele com#N/A
Worksheet 2 Column A B
termcategory
telecom Telecom
telcom Telecom
tele comTelecom
What I want to do is pull the category name from worksheet 2
Sanjoy,
Thanks for your reply. I suspect you are saying that if I press F2 in
something like Visual Studio I will get a page come up that will show the
values for the constants/enumerations. (I'm not at a place that I can check
VS).My question may be a bit more fundamental. When I try to
Hi Gurus,
I Just want to create Diff excel sheet based onn Emp name sheet name
should be emp name date.there are diff test are available for each
process I also want to update that process test scores in respective sheet
(kindly see the sheets for more info),i am having very large excel
I ahve a workbook for each of my staff for coaching purposes, I need
to save this into a Common drive so they can password protect it to
enable only me and them to access it. I also need to save it without
a password into a management drive to allow my manager to access it
without the need for a
Hi Paul,
Thanks for your help. I think I now understand how it works. After I
sent you the file I tried what is suggested in below link one more
time and it works great. It is basically the same thing that you told
me to do with a little bit of change.
Here is the link for anybody interested:
The command you're looking for is SaveCopyAs
I would create a BeforeSave event,
there, save the file locally, then define the backup location, unprotect the
file, then save a copy at the backup location.
Let me know if you need specifics.
Paul
From: balders
Hi Mike,
Please use:
=VLOOKUP(A2,Sheet1!B:B,1,0) instead.
Regards,
Andy
On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike michael.lovel...@gmail.comwrote:
I am struggling with this and wondering if you could help..
Worksheet 1 Column A B
Keyword Category
telecom Telecom
tele com#N/A
can you please attach the sample workbook
On Tue, Feb 15, 2011 at 11:58 PM, MikeMikeMike
michael.lovel...@gmail.comwrote:
Say for example I have one tab that has a list of contact information
- say anywhere from 1000 to over 100,000 contact items that include
name (one field for first and
Private Sub Workbook_BeforeClose(Cancel As Boolean)
' with password
ThisWorkbook.SaveAs Filename:=d:\test3.xls , FileFormat:= _
xlNormal, Password:=abc, WriteResPassword:=abc1,
ReadOnlyRecommended:=False _
, CreateBackup:=False
'without password
ThisWorkbook.SaveAs Filename:=d:\test.xls
End Sub
see if this helps
Sub growth()
Dim i As Long
i = Range(s21).End(xlDown).Row
Columns(S:S).Select
Selection.Insert Shift:=xlToRight
Range(S21).Select
ActiveCell.FormulaR1C1 = Growth
Range(S23).Select
ActiveCell.FormulaR1C1 = =(RC[-2]-RC[-1])/RC[-2]
Range(S23).Select
29 matches
Mail list logo