how to get the first used cell position in VBA?

[Guest]

I use the (Sheet).UsedRange.Columns.Count in my code, so I need a first used
cell position to copy all the cells to the array.

Excel 2003

Can you leave the hyperlink for the object library here? I can't find it on
MSDN. Thank you in advance!

 

[NickHK]

Not sure what you are trying to achieve, but maybe
(Sheet).UsedRange.Copy

As for reference material.

Whilst there this for v11, it's a bit limited:
http://msdn2.microsoft.com/en-us/library/aa176808(office.11).aspx

Better here for v10:
http://msdn2.microsoft.com/en-us/library/aa141044(office.10).aspx

Best v12:
http://msdn2.microsoft.com/en-us/library/bb149081.aspx

NickHK

 

[Bob Phillips]

cells(activesheet.usedrange.row,activesheet.usedrange.column)

will give you the first used cell

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gary Keramidas]

will this work?

activesheet.usedrange.range("a1").Address

 

[Bob Phillips]

Should do Gary.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gary Keramidas]

ok, thanks bob

--


Gary

Should do Gary.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hi NickHK,

It is empty here.

http://msdn2.microsoft.com/en-us/library/aa176808(office.11).aspx

But thank you all the same!