| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing a range that changes all the time
Hi experts,
I have data starting from A1 to M... I would like to count the rows to print based on the input in column B !!! I have the following code for printing a range. Dim rngprint As Range Sheets("Outputdlnrs").Select Set rngprint = Range("A1", Range("A1").End(xlDown).Address) ActiveSheet.PageSetup.PrintArea = rngprint.Address Selection.PrintPreview This does not work because only A1 is selected each time. Does anybody have the right formula ? Thanks, Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200510/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| page set up on excel to get 100% @ time of printing | Setting up and Configuration of Excel | |||
| How can I do one-time printing without set page breaks? | Excel Discussion (Misc queries) | |||
| printing time literally | Excel Programming | |||
| Printing a range that is determined at run time | Excel Programming | |||
| VB code for printing one page at a time | Excel Programming | |||
![Pierre via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
