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. |
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. |
MACRO SELECT COLUMN
i can do that.. note: would make this a comment to somewhere, i don't know
if what I come up with might be unique ?? / , but everytime I give all the details, people skip the request. not saying this as maybe, observed that at 100%.. better to do in pieces. just trying to copy a formula to selected cells, with a couple of twists: - skip rows where column A has a period ".", to name one doesn't change anything about selecting a specific set of rows in a column. thanks. "מיכאל (מיקי) אבידן" wrote: Until you get a "better" reply may I suggest that you explain, in details(!), your aim so we can focus on the target without having to debugg the code. Micky "Dan" wrote: 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. |
All times are GMT +1. The time now is 05:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com