Hi all
How can I improve my macro which has a macro error like below:

"Macro error
The method can't be used in the applied context. Specifically, some Range
object methods require that the range contain data. If the range does not
contain data, the method fails."

How can I modify range object which has some empty data in the range?
Thanks
Daniel