Variable

[oleg_v]

hi

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

[VBA] g = Sheets("sheet3").Range("B65536").End(xlUp).row[/VBA]

thanks

[Bob Phillips]

[vba]

With Worksheets("Sheet3")

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

[oleg_v]

[vba]

With Worksheets("Sheet3")

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

It writs me "syntax error"

what should i do?

[Bob Phillips]

Sorry, should be

[vba]

With Worksheets("Sheet3")

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

[oleg_v]

Sorry, should be

[vba]

With Worksheets("Sheet3")

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

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
[VBA]
Set rng = Cells(2,1)
[/VBA]