Jagwarman
asked on
populate if blank otherwise do nothing
I have a specific [large] range of cells which, when the file opens gets populated if the cells are blank. If however these cells are already populated I do not want the code to overwrite what is already there.
Can an expert provide me with the code that will prevent the cells being populated if they already have data in them.
Many thanks
don-t-overwrite.xlsm
Can an expert provide me with the code that will prevent the cells being populated if they already have data in them.
Many thanks
don-t-overwrite.xlsm
The code you have already does that. If you are facing a problem the please tell us the cell address and we can check.
ASKER
Hi Saqib Husain, Syed
it works first time, but if you save and close then open again it falls over
Error 1004. No cells were found.
it works first time, but if you save and close then open again it falls over
Error 1004. No cells were found.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so so simple ..... when you know how,
thanks
thanks