Range Selection

  • Thread starter Thread starter M@DG33K
  • Start date Start date
M

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
 
Hi again

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

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