Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range from second row onward
hello,
Im writting a vba function to import an excel file and where it asks for the range i know i can use SheetName$ to grab the entire sheet, but how would i code it to grab the entire sheet from row 2 onward? The program im writing this in is access, but i wasnt sure if this was the correct msg board to post to or not. thanks for the help! Ben |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range from second row onward
Range("2:65536")
"Ben" <ben_1_ AT hotmail DOT com wrote in message ... hello, Im writting a vba function to import an excel file and where it asks for the range i know i can use SheetName$ to grab the entire sheet, but how would i code it to grab the entire sheet from row 2 onward? The program im writing this in is access, but i wasnt sure if this was the correct msg board to post to or not. thanks for the help! Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Help please in selecting range dependent on another range | Excel Programming | |||
Selecting a Range inside a range | Excel Programming | |||
Help with selecting a range... | Excel Programming | |||
selecting a range | Excel Programming |