I have a worksheet with 15 rows (row 4 thru 19) and 4 columns (column A thru D)
I need a macro that does the following for each row:
If the value of D in a row = "Recorded"
then
ClearContents of column B, C, and D in that row
Thanks
I have a worksheet with 15 rows (row 4 thru 19) and 4 columns (column A thru D)
I need a macro that does the following for each row:
If the value of D in a row = "Recorded"
then
ClearContents of column B, C, and D in that row
Thanks
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Try this:
Please Login or Register to view this content.
Thanks you 2, worked great
Yet another one
Please Login or Register to view this content.
Last edited by AB33; 12-28-2012 at 09:48 AM.
@AB33
that would clear the entire column not just the relevant rowPlease Login or Register to view this content.
@cbrd,
you're welcome :-)
please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')
Jay,
Thanks Jay for your correction!
Had I seen your code before I posted it,I would have refrained from doing so, as I had ended-up with the same code as his highness.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks