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.

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.

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.