Macro to find empty cell and select range to print selected.

  • Thread starter Thread starter vincentwongau
  • Start date Start date
V

vincentwongau

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.
 
Dim rng As Range
Set rng = Range("A1").Resize(Range("W14").End(xlDown).Row, 26)
ActiveSheet.PageSetup.PrintArea = rng.Address


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Dynamic Offset from an Application.Goto cell = Date or Time 10
List sorting and macros 3
Count no empty cells at the right of a selection 2
Macro to "find" the next empty cell in a range 2
find range and fill down 3
Code for multiple select of cells 16
Autofill macro - variable destination cells 7

Back
Top