This worked:
ActiveWorkbook.Worksheets("MyList").Range("B2:C37").Sort _
Key1:=Worksheets("MyList").Range("B2:B37")
I had to put the .Range in the statement before the Sort method.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Thank you for the attempt, but this did not work. If I use your code
example, I get the same runtime error on this line:
With ActiveWorkbook.Worksheets("MyList").Sort
I don`t understand why this does not work!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
e line,
> since if you aren't ON Sheet1 when you run the macro,
> you probably aren't going to be in the correct cell anyway!!!
>
> Is that what you're looking for?
>
> to make sure you don't have the wrong cell selected,
> you could use:
>
> If (act
umn = 2) Then
hope this helps,
paul
____________
From: pete
To: MS EXCEL AND VBA MACROS
Sent: Sun, November 29, 2009 10:02:43 PM
Subject: $$Excel-Macros$$ Re: Excel 2003 XP pro - how to reference an adjacent
cell in a formula
Please disregard previous post
Further to m
If you don't want any Row offset, then you would need: .Offset(0, 2)
>
> I can't quite figure out how your data is set out. Can you describe it to me,
> or can you attach a sample workbook?
>
> Regards - Dave.
>
>
>
>
>
> > Date: Mon, 30 Nov 2009 00:01
kbook?
Regards - Dave.
> Date: Mon, 30 Nov 2009 00:01:26 -0800
> Subject: Re: $$Excel-Macros$$ Re: Excel 2003 XP pro - how to reference an
> adjacent cell in a formula
> From: sq...@netspace.net.au
> To: excel-macros@googlegroups.com
>
> Hi Dave
>
> Thanks for he
gt;
> As to your formula, after I ran your code, it was relative, not absolute, so
> not sure what you mean by your question.
>
> BTW, if you use my shortened code, you may have to adjust the offset values
> in lines 4 and 5, since the ActiveCell stays constant.
>
> What
Regards - Dave.
> Date: Sun, 29 Nov 2009 19:02:43 -0800
> Subject: $$Excel-Macros$$ Re: Excel 2003 XP pro - how to reference an
> adjacent cell in a formula
> From: sq...@netspace.net.au
> To: excel-macros@googlegroups.com
>
> Please disregard previous post
&g
Please disregard previous post
Further to my post below I have been able to come up with the
following which calculates & inserts interest amount in D5. (Copies &
pastes the last balance & applies a formula)
1.Worksheets("Sheet1").Activate
2. ActiveCell.FormulaR1C1 = "Interest"
3.ActiveCell
Hi
I've got this sub doing what I want, but is there a more elegant/
professional way?
Sub Interest()
'
Worksheets("Sheet1").Activate
ActiveCell.FormulaR1C1 = "Interest"
ActiveCell.Offset(rowOffset:=-1, columnOffset:=3).Activate
ActiveCell.Copy
ActiveCell.Offset(rowOffset:=1,
Further to my post I have modified my code using offset, however I'm
having trouble inserting the formula to calculate interest:
Worksheets("Sheet1").Activate
ActiveCell.FormulaR1C1 = "Interest"
ActiveCell.Offset(rowOffset:=0, columnOffset:=2).Activate
ActiveCell.FormulaR1C1 = "=R[-1],
please sent any attachemet
On 11/6/09, Tonto wrote:
>
>
> http://office.microsoft.com/en-us/excel/HP052091331033.aspx
>
> If this function is not available, and returns the #NAME? error,
> install and load the Analysis ToolPak add-in.
>
> John
>
> On Nov 5, 2:32 pm, eric wrote:
> > dear ms excel
http://office.microsoft.com/en-us/excel/HP052091331033.aspx
If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
John
On Nov 5, 2:32 pm, eric wrote:
> dear ms excel experts:
> my name is eric lin, I had ms excel 2003, but when I open
ocity ostate dcity dstate
frankfort in london uk
frankfort in paris EU
henderson ky london uk
henderson ky london uk
orange ca paris eu
orange ca mt pleasant mi
i would like to add two empty rows at the end of each ocity.
ocity ostate dcity dstate
frankfort in london uk
frankfort in paris EU
henderson ky london uk
henderson ky london uk
orange ca paris eu
orange ca mt pleasant mi
i want to add two or three rows of empty rows at the end of ea
Can u send a sample sheet with the grouping this can be done with
a macro.
On Sep 17, 7:27 am, subs wrote:
> hi
>
> I would like to add a couple of empty rows at the end of each grouping
> in a spreadsheet. i.e instead of adding any subtotals, i would like to
> keep two rows empty at the en
Hi
See if this helps
http://134.198.33.115/webworks/Excel.05.ppt
Ashish
On Wed, Mar 25, 2009 at 10:44 AM, lingesh p wrote:
> Hi
>
> I'm looking for a ppt presentation on "introduction to excel 2003". is there
> any one who can help me in this regard. if any one have an ppt on this can
> mail
17 matches
Mail list logo