Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO SELECT COLUMN
Hello, I am trying to make a macro to select a column, preferably from preset
rows, but if I select the first cell, I have: Dim C6 As String C6 = Range("C6") 'C6 has: =ROW($A$1000) 'to designate the last row Range(ActiveCell, ActiveCell.Offset(1000, 0)).Select How do I include C6 in the above line, thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO SELECT COLUMN
note: offset 1000 not same as last row
maybe will need to change what is in C6 to a: ROW minus ROW.. =ROW($A$1050)-ROW($A$50) "Dan" wrote: Hello, I am trying to make a macro to select a column, preferably from preset rows, but if I select the first cell, I have: Dim C6 As String C6 = Range("C6") 'C6 has: =ROW($A$1000) 'to designate the last row Range(ActiveCell, ActiveCell.Offset(1000, 0)).Select How do I include C6 in the above line, thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't select a macro | Excel Discussion (Misc queries) | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
select detail in column B if column A = date | Excel Worksheet Functions |