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

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