Macro User Input

[tallguy6354]

Hi guys,

I would like to do a Macro which requires user to go to a specific line which is variable in each work sheet. I would like to be able to enter the number and then delete all lines below that point and then continue with the balance of the macro.

Is there an easy way to pause the Macro and then restart it? Or is there a code that I can insert in the Macro to locate a specific Cell and then delete all lines below the next line?

[JBeaucaire]

Yes, all that is doable. Describe the criteria for selecting this one particular cell that makes it unique or the first of it's kind.

[tallguy6354]

Thnaks for the interest.

The first blank cell in Columm D see the Book3.xlsx

I want to delete all data for the entire sheet from line 5 down. The last line of data in columm D varies with each file.

[shg]

Try this:

Please Login or Register  to view this content.

[tallguy6354]

Thank you,

I just had to eliminate the Sub x and I inserted it after the last line of my Macro and it works perfectely.