Put "');" above each empty cell in selection

[wali]

Hello every one,

i need a code which looks for empty cells in the selection and puts "');" in the cell above it. If the cells above the empty one already have content that should be deleted and "');" should be pasted there instead. I need to put this symbol combination above all empty cells in my selection.

Thank you for your help in advance.

[pike]

Hi wali

Please Login or Register  to view this content.

after 270 posts you should attach your efforts instead of I need

[JBeaucaire]

Without a loop, this might do it for you:

Please Login or Register  to view this content.

[wali]

Hi Pike,

I try to understand each time the code to of solutios so that i can try on my own next time. But as having Dyscalculia i cant. I hope that it will come and its my wish that some time i can give back this forum what i was given.

Thank you very much for your help.

[wali]

Hi JBeaucaire,

thank you very much for your help.

[contaminated]

Seens I late, but in any case i'm posting code

Please Login or Register  to view this content.

[wali]

Dear Pike,

Sorry i was too quick with marking it solved. Your code replaces all cells with "');". But only those which are above empty one should get "');" as their content. I am sending an example file in which the cells A19, A29 and A48 should get the content "');".

[wali]

Dear contaminated,
thank you very much. Your code worked for me when i changed the column names from A to the one i need to make changes in. Thank you very much.

[contaminated]

Really?!. I really didn't expected

If so. please mark thread as solved and add reputation pls....

EDIT
Already marked as solved

[pike]

strange... going back to nuts and bolts try..

Please Login or Register  to view this content.

[pike]

Hey contaminated
never ever to late. its allways go to see other options and every ones efforts
how else do we learn
hi wali
Ive tested this one

[JBeaucaire]

I still think my loopless code does what you want. If you want the macro to figure out what to highlight on its own, then maybe:

Please Login or Register  to view this content.

[wali]

Hi you all three,
now i have three working solutions. Thank you very very much.

[pike]

three times as happy