VBA save a cell address(only number) as variable

[mohamadba91]

How can i save only the number of active cell address as a variable in vba code
for example cell address is I$I4078 and in need 4078

 

[Fluff]

How about

   Dim Rw As Long
   Rw = ActiveCell.Row

 

[mohamadba91]

How about

   Dim Rw As Long
   Rw = ActiveCell.Row

I really appreciate
would you help me on this please, it seems there is a problem in last line

Dim LCNum As Long
Range("I2").Select
Selection.End(xlDown).Select
LCNum = ActiveCell.Row
Range("E2: E " & LCNum & "").Select

 

[Fluff]

Try

Dim LCNum As Long
Range("I2").Select
Selection.End(xlDown).Select
LCNum = ActiveCell.Row
Range("E2:E" & LCNum).Select

or simpler

Range("E2:E" & Range("I2").End(xlDown).Row).Select

 

[mohamadba91]

thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback