Good Afternoon,
I am attempting to create a macro to clear contents of a range of cells on multiple columns.
My example would be
Clear contents of F8:F59, K8:K59 and so on. I will assign this to a button on top of each worksheet to clear multiple column ranges more than the example above. If i can get a start i can add the rest of the range of cells.
Thank you.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
I tried that exact code earlier and got a dialog box with 400 in it. Am i missing something?
Was that an error message that you got? if so, could you attach a copy of your file? Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.
It was a dialog box that has a red x on the left side with "400" beside it. No other message to indicate a message. I will have to create a sheet that doesnt have some of the confidential data in it.
Its basically a pricing template that i use and copy as a new workbook. The columns in question are for quantity of materials. I only want those cleared but continue to use the rest of the data. Again, I can upload a sample shortly.
Add the following lines to the code and report back the description
Please Login or Register to view this content.
Try this, with some of the quote marks removed
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks