| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to get the first used cell position in VBA?
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get the first used cell position in VBA?
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/lib...ffice.11).aspx Better here for v10: http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx Best v12: http://msdn2.microsoft.com/en-us/library/bb149081.aspx NickHK "DFDY" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get the first used cell position in VBA?
Hi NickHK,
It is empty here. http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx But thank you all the same! "NickHK" wrote: 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/lib...ffice.11).aspx Better here for v10: http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx Best v12: http://msdn2.microsoft.com/en-us/library/bb149081.aspx NickHK "DFDY" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get the first used cell position in VBA?
cells(activesheet.usedrange.row,activesheet.usedra nge.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) "DFDY" wrote in message ... 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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get the first used cell position in VBA?
will this work?
activesheet.usedrange.range("a1").Address -- Gary "Bob Phillips" wrote in message ... cells(activesheet.usedrange.row,activesheet.usedra nge.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) "DFDY" wrote in message ... 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! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get the first used cell position in VBA?
Should do Gary.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... will this work? activesheet.usedrange.range("a1").Address -- Gary "Bob Phillips" wrote in message ... cells(activesheet.usedrange.row,activesheet.usedra nge.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) "DFDY" wrote in message ... 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! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get the first used cell position in VBA?
ok, thanks bob
-- Gary "Bob Phillips" wrote in message ... Should do Gary. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... will this work? activesheet.usedrange.range("a1").Address -- Gary "Bob Phillips" wrote in message ... cells(activesheet.usedrange.row,activesheet.usedra nge.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) "DFDY" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move within ss by active cell position, NOT by cell names | Excel Programming | |||
| Displaying a cell relative to the position to another cell | Excel Discussion (Misc queries) | |||
| Position of CellCursor on Screen (absolute position) | Excel Programming | |||
| cell position | Excel Programming | |||
| Cell Position | Excel Programming | |||
Hybrid Mode
