| 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 |
| 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 | |||
Threaded Mode
