I’d like to check Column BD for rows with no data. When I find a row without data I would like to copy that same row of Column K and paste it into Column BD. The macro below works great with dates but not text which is the data I am working with. Can you assist me?
Please Login or Register to view this content.
Last edited by Sal1; 08-31-2010 at 10:49 PM. Reason: SOLVED
Hi Sal, would this not work?
Please Login or Register to view this content.
Thank you for the help, I appreciate it very much. I am getting an error message when I run the code 'Run-time error '1004', no cells were found' Do you know what I might have done to cause this? Sometimes rows in Column K are without data, I am not sure if that makes a difference. When I try to Debug it this line of code is highlighted in yellow 'Range("BD1:BD" & LR).SpecialCells(xlCellTypeBlanks).Value = Range("K1:K" & LR).Value.' Any thoughts?
My guess is that the macro didn't find any blanks in column BD. Are they really blank, or are they formulas that are resulting in an empty string ("")?
I used the SpecialCells call hoping that they would be blanks and we wouldn't need a loop to test each cell in BD. If a loop is needed, so be it.
Please Login or Register to view this content.
Just what the doctor ordered. Thank you my friend it works perfectly now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks