Range Selection

[M@DG33K]

Hi Again

I was tryin gto programatically select a range basis the current
position and a fixed reference

I'm using the following code snippet

Dim CurrentCell As String

CurrentCell = ActiveCell.Address

Range("b1:CurrentCell").Select

It gives an error 400 and exits

any ideas as to what am I doing wrong?

regs

Chirag

 

[Leo Heuser]

Hi again

Try
Range("b1:" & CurrentCell).Select

In
Range("b1:CurrentCell")
Excel will "see" CurrentCell as a
string of characters, not as a variable.