selecting used area

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi All

how do i select the used area (or refer to the used area) of a worksheet in
code when i want to exclude column B?
Used area is A to J from row 1 to unknown.

Thanks
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel VBA Worksheets group tables in one table. 1
Set Print Area with Dynamic Start Point 2
VBA group the number in the Column and Copy to the new worksheet. 0
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
VBA to set dynamic print area 1
Print Area Range Selection 2
Copy Multiple Areas from One Workbook to Another 4
Selecting Range Based on Cell Content then Copy/Paste to New Sheet,Looping 2

Back
Top