View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vincentwongau@gmail.com is offline
external usenet poster
 
Posts: 3
Default Macro to find empty cell and select range to print selected.

I am having problems developing a macro to find the first empty cell in
the column range w14:w121.

Upon finding the first empty cell in the W column range it should off
set to column Z and do a ctrl-shift-home to select the last selected
cell up to cell A1 and print selection.

I have looked through google but cannot make sense of using ifempty or
using some other method to determine the first empty cell.