Thread: selecting cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] philipl@vistatec.ie is offline
external usenet poster
 
Posts: 6
Default selecting cells

hi

I have need to select two columns from a spreadsheet, I don't know how
long these columns are going to be until runtime. I would like to be
able to select this at run time so I can write out to a text file.

I am able to get the last value in one column by using range and
intersect. And the other one this way too, so with this I should be
able to work out the cordinates for my selection area.

this seems a liitle long winded, does anyone else out there have a
better way of doing this?

thx
-Philip