I explained what can be done.

--
Regards,
Tom Ogilvy


"droopy928gt"
wrote in message
...

Hi Tom,

Thanks for the reply.

When I refer to data I'm referring to a cell with data in it, not an
area.

When a range is made up of consistent non empty cells you can use
Item(5) to select the 5th item from that range. When I use this in
combination with a range made using .SpecialCells(xlConstants) then
item 1 will be the first item from the range where ever it may be
located, which is correct. Further items though are not correct in
cases where there are empty cells in between pieces of data.

In case of e.g. a range containing data in cells J7,J10,J11. What you
would get is e.g item 1 is J7, Item 2 is J8 and and item 3 is J9.

So I was hoping for there to be a way to directly address data in a
range using a accessing method like .item(x).

From your reply though this doesn't sound like being possible, right?


--
droopy928gt
------------------------------------------------------------------------
droopy928gt's Profile:
http://www.excelforum.com/member.php...o&userid=30232
View this thread: http://www.excelforum.com/showthread...hreadid=499064