VBA Blank cells

[NatxUK]

Hi Folks

Great site, lots of useful stuff. I am looking for some advice on VBA. I have written a script to transfer information from a set of cells to a new worksheet and then protect and hide, but i need the code to stop if it finds that any of the cells that it should be transferring are empty. Any ideas.. Pllleeeeaaaseeeee

Nat

[Ivan F Moala]

On 2002-05-21 04:23, NatxUK wrote:
Hi Folks

Great site, lots of useful stuff. I am looking for some advice on VBA. I have written a script to transfer information from a set of cells to a new worksheet and then protect and hide, but i need the code to stop if it finds that any of the cells that it should be transferring are empty. Any ideas.. Pllleeeeaaaseeeee

Nat

Hi Nat, I'm assumnig you are search for the
cells to copy via a Loop ??
Loops can be slow.
Instead, consider filtering out the empty
cells before coping ie. Applying a filter
Copy then paste.

Easiest way to do this is to Turn your
macro recorder on and do the steps.
Have a look @ the code.....Post if you get stuck.