Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cells with VBA
Hi:
Can anyone tell me if I can use VBA to select a range of cells, with the Active Cell being an unknown cell in column A. I am using the following: Sheets("INV").Cells(65536, 1).End(xlUp).Offset(1, 0).Select to find the last cell and select the cell below. At that point, I need to select the active cell and several cells below it in the same row. Any help appreciated Thanks, Sam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cells with VBA
Use
Selection.Resize(X).Select Where x is the 'Total' number of rows you want the resize to b ----- Sam Fowler wrote: ---- Hi Can anyone tell me if I can use VBA to select a range of cells, with the Active Cell being an unknown cell in column A I am using the following: Sheets("INV").Cells(65536, 1).End(xlUp).Offset(1, 0).Selec to find the last cell and select the cell below. At that point, I need to select the active cell and several cells below it in the same row Any help appreciate Thanks Sa |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Cells with VBA
You can combine them:
Sheets("INV").Cells(65536, 1).End(xlUp).Offset(1,0).Resize(X).Select But consider whether you really need to select those X cells to do whatever comes next. Alan Beban chris wrote: Use: Selection.Resize(X).Select Where x is the 'Total' number of rows you want the resize to be ----- Sam Fowler wrote: ----- Hi: Can anyone tell me if I can use VBA to select a range of cells, with the Active Cell being an unknown cell in column A. I am using the following: Sheets("INV").Cells(65536, 1).End(xlUp).Offset(1, 0).Select to find the last cell and select the cell below. At that point, I need to select the active cell and several cells below it in the same row. Any help appreciated Thanks, Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Why aren't my cells highlighted when I select multiple cells? | Setting up and Configuration of Excel |