run-time 1004 when referencing a range

**kamelkid2** · 07-16-2012, 08:11 AM

Please Login or Register  to view this content.

errors on the two statements attempting to clear. i have been through all my resources and they are saying this should be correct so it must be something silly i am missing. is this the proper way to address this range when using a variable?

thank you

**Richard Buttrey** · 07-16-2012, 08:18 AM

Hi,

What are the values of B6, B13 & B14?

**tom1977** · 07-16-2012, 08:25 AM

Hi try this

Please Login or Register  to view this content.

**kamelkid2** · 07-16-2012, 08:26 AM

B6 is the following function which returns a value of 31

Please Login or Register  to view this content.

B13 is the following function which returns a value of 477

Please Login or Register  to view this content.

B14 is the following function which returns a value of 505

Please Login or Register  to view this content.

**kamelkid2** · 07-16-2012, 08:29 AM

Originally Posted by tom1977

Hi try this

Please Login or Register  to view this content.

thank you for this help. applying With has fixed my issue. do you happen to know what necessitated this to be declared? i thought i had clearly defined the paths that i was to be working in

**tom1977** · 07-16-2012, 08:34 AM

Your variant variable was ok (I have change this because the long variable has less capacity) Real problem was that fragment of code like this
Worksheets("user").Range(Cells(1, 1), Cells(StartDelete1 - 1, 1)).Clear
always refers to active worksheet even You put Worksheets("user"). before this