Subscript Out of Range

[Manan]

Hi ,

Do not know why this is throwing error at this point . Cell A2 is Numeric with 0 Decimal Places.

Dim BlockI As Integer
Dim Block_Number As Long
BlockI = 1
Block_Number = Sheets("Reverse_Copy").Range("A2")
 
Error :- Runtime error 9 , Subscript out of range.

Any help on this??

 

[Smallman]

Hi

Would you like to double check the data in A2. You are saying it is a number but does it just look like a number and is maskerading as text.

The code seems to work OK. So just need to see your file now.

Take care

Smallman

 

[NARAYANK991]

Hi ,

This error can come if the sheet referred to does not exist ; even if it exists , its name may differ due to leading / trailing spaces.

Narayan