| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to find empty cell and select range to print selected.
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) wrote in message oups.com... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert selected cell value into next cell in range that is empty | Excel Worksheet Functions | |||
| Using a macro to select a print range | Excel Programming | |||
| Macro to print a selected range, not entire worksheet | Excel Discussion (Misc queries) | |||
| select first empty cell in a range | Excel Programming | |||
| Macro to select non empty rows in a given range | Excel Programming | |||
Linear Mode
