Macro for printing

  • Thread starter Kathryn J Bittman
  • Start date
K

Kathryn J Bittman

We are working on a project in Office 2000 on Excel. The problem we are
trying to solve is to have macro to print a list. However, the list will
change (shrink/grow) so selected ranges in our macro is not working. Is there
a way to build one to select a print area, then print?

We have also tried it in Excel 2003 - still no luck.

All help is appreciated!
 
J

JE McGimpsey

Kathryn J Bittman said:
We are working on a project in Office 2000 on Excel. The problem we are
trying to solve is to have macro to print a list. However, the list will
change (shrink/grow) so selected ranges in our macro is not working. Is there
a way to build one to select a print area, then print?

We have also tried it in Excel 2003 - still no luck.

All help is appreciated!
Click to expand...

I'm sure there's a way, but I can only guess what your list might
consist of. Perhaps if you described your layout a bit...
 

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

Macro warning in word 1
Document won't print 0
Page numbering with Merged Document and IF statements 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
VBA word change keys 0
Converting URLs in comments to Markdown-formatted links 2
Setting language of a selected text in Office apps. 0
Drop down list control value in vba 2

Top