Variable

[oleg_v]

hi

how can i change the range in the row below into a variable

g = Sheets("sheet3").Range("B65536").End(xlUp).row

thanks

[Bob Phillips]

With Worksheets("Sheet3")

g = .Cells(.Rows.Count, "B").End(xlUp).Row
Set rng = .Range("B1"),Resize(g)
End With

[oleg_v]

With Worksheets("Sheet3")

g = .Cells(.Rows.Count, "B").End(xlUp).Row
Set rng = .Range("B1"),Resize(g)
End With


It writs me "syntax error"

what should i do?

[Bob Phillips]

Sorry, should be



With Worksheets("Sheet3")

g = .Cells(.Rows.Count, "B").End(xlUp).Row
Set rng = .Range("B1").Resize(g)
End With

[oleg_v]

Sorry, should be



With Worksheets("Sheet3")

g = .Cells(.Rows.Count, "B").End(xlUp).Row
Set rng = .Range("B1").Resize(g)
End With


how can i write this macro that instead of "B" will be 2 and instead of
"b1" will be (2 & 1)

[Aussiebear]

Are you changing yet again the substance of a question because you didn't ask the correct question or supply the correct data at the initial post?

[mdmackillop]

Check out the Cells notation eg

Set rng = Cells(2,1)