VBA to clear dynamic range based on cell value

[gjwilson1216]

Hello,

I have this line of code that isn't working


Range("AV" & Sheets("Setup").Range("AT1").Value & ":AV50000").Clear


What I need: Cell AT1 has a number in it, I need to clear everything for the cells in row AV starting in the number in AT1 through row 50000.

I tried a couple different variations and Im just not getting it. This is my last attempt, I know it was a long shot but I ran out of ideas.

Grant

[davesexcel]

You could be missing other details, but here is my interpretation. Besides the variables, the codes look exactly the same, if it doesn't work, you may have to supply a sample.

Please Login or Register  to view this content.

[YasserKhalil]

As for me it's working

Please Login or Register  to view this content.

When running the code ..What's the active sheet that you worked on?
Have you got more that one sheet?
I tried this line in "Sheet1" .. But the value in AT1 was put in "Setup" sheet

[TMS]

There's nothing wrong with the code; it works fine.

What's in cell AT1 on the Setup worksheet? Is it a positive number? What sheet is selected? Is the sheet protected? What happens? Do you get an error message? If yes, what is it? If no, does it just do nothing? Or does it clear somewhere else?

Please Login or Register  to view this content.

Regards, TMS

[gjwilson1216]

I got it to work.....sort of

I came up with this idea as a fix for my main problem here

http://www.excelforum.com/excel-prog...ml#post4009054

but I am still getting the blank cells inbetween entries