Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range - using Offset ( 40 ,0 ) - not working
hi there
having a real blonde moment - i need to (n is already defined) ActiveSheet.Range("E9").Activate ActiveCell.Offset(0, n).Select then select activecell(down 40, 0) not move, basically if n = 2 ActiveSheet.Range("E9").Activate ActiveCell.Offset(0, 2).Select range(F9:F40).select please help - really dumb today thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range - using Offset ( 40 ,0 ) - not working
Hi Buffyslay,
Try: Range("E9")(1,2).resize(32).Select It is, however, rarely necessary to select a range and it is invariably more efficient not to do so.. --- Regards, Norman "Buffyslay" wrote in message m... hi there having a real blonde moment - i need to (n is already defined) ActiveSheet.Range("E9").Activate ActiveCell.Offset(0, n).Select then select activecell(down 40, 0) not move, basically if n = 2 ActiveSheet.Range("E9").Activate ActiveCell.Offset(0, 2).Select range(F9:F40).select please help - really dumb today thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range - using Offset ( 40 ,0 ) - not working
hi there
what i needed to do was ActiveSheet.Range("E9").Activate ActiveCell.Offset(0, n).Select ActiveCell.Range("A1:A250").Select where the the A1 actually refers to the active cell not the actual call A1! odd behaviour i know but thanks for the reply _________________________________________ Willow: "I knew it! I knew it! Well, not in the sense of having the slightest idea, but I knew there was something I didn't know." http://www.buffyslay.co.uk *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range - using Offset ( 40 ,0 ) - not working
Hi Buffyslay,
If n = 40, what is the address of the intended selection range? --- Regards, Norman wrote in message ... hi there what i needed to do was ActiveSheet.Range("E9").Activate ActiveCell.Offset(0, n).Select ActiveCell.Range("A1:A250").Select where the the A1 actually refers to the active cell not the actual call A1! odd behaviour i know but thanks for the reply _________________________________________ Willow: "I knew it! I knew it! Well, not in the sense of having the slightest idea, but I knew there was something I didn't know." http://www.buffyslay.co.uk *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range - using Offset ( 40 ,0 ) - not working
what i needed to do was
ActiveSheet.Range("E9").Activate ActiveCell.Offset(0, n).Select ActiveCell.Range("A1:A250").Select n = 250 in this example - yes i should have put ActiveCell.Range("A1:A40").Select but i was copying it from my actual workings.... _________________________________________ Willow: "I knew it! I knew it! Well, not in the sense of having the slightest idea, but I knew there was something I didn't know." http://www.buffyslay.co.uk *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table | Excel Worksheet Functions | |||
range("a1").select not working | Excel Discussion (Misc queries) | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Select and Copy Range using Offset | Excel Programming | |||
Range().Select Not Working | Excel Programming |