VBA code for copying on a range were cells are blank

[Lindsey M]

Hi everyone, me again!!

So, you were all so helpful with my earlier prob, thought i'd keep you going
with another prob i'm having.

OK, so what I want to do (in VBA if poss), is to search the range B2:E2 and
see if they are blank. If yes, then I want to copy the cells above and then
carry on searching that range. I can't do it upwards as its likely that
there are going to be more than one set of blanks, e,g.

A B C D E
F
1 Joe Bloggs | 309873 | Smith, John | 08:00 | 12:00 | Back Office
2 | | | |
| Lunch
3 | | | |
| Assisting
4 Mary Patt | 203949 | Brunell, Ian | 10:00 | 16:00 | Back Office

Any help, as always, would he hugely appreciated

Cheers
Linds

 

[Lindsey M]

Ok, ignore the above, i've done it now, woohoo!! - thanks anyway!!

Hope this finds everyone well..... )

Linds

 

[Ken Wright]

But you didn't tell us how

Anyway, just in case it is different, you can select the entire range, do
Edit / Go To / Special / Blanks, type = and then hit the UP arrow once and
then enter it using CTRL+ENTER. Record that and then clean it up.