Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 13
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 301
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting range in list of range names depending on a cell informa Courreges Excel Discussion (Misc queries) 2 June 19th 06 10:59 AM
Help please in selecting range dependent on another range MickJJ Excel Programming 2 January 10th 05 12:01 PM
Selecting a Range inside a range hcova Excel Programming 0 July 13th 04 03:26 PM
Help with selecting a range... Ron de Bruin Excel Programming 0 July 22nd 03 03:37 PM
selecting a range David Excel Programming 2 July 21st 03 11:14 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"