Login

Search the forums now!

Welcome, Guest. Please login or register.

October 21, 2025, 10:11:39 pm
Pages: [1]   Go Down

Author Topic: Excel Macro  (Read 2005 times)  Share 

0 Members and 1 Guest are viewing this topic.

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Excel Macro
« on: August 06, 2009, 05:00:30 pm »
0
Hey guys

Is it possible to create a macro to print preview a specific set of cells from an entire worksheet?

eg. I want to print preview A3:F8 and A27:B35

Thanks :)

Logged
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E

kurrymuncher

  • Guest
Re: Excel Macro
« Reply #1 on: August 06, 2009, 05:02:24 pm »
0
Quote from: cobby on August 06, 2009, 05:00:30 pm
Hey guys

Is it possible to create a macro to print preview a specific set of cells from an entire worksheet?

eg. I want to print preview A3:F8 and A27:B35

Thanks :)



yeah it is. Its in the notes that are on the portal   -_-
Logged

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Re: Excel Macro
« Reply #2 on: August 06, 2009, 05:08:00 pm »
0
found it :P


But when i make the print preview selection, it appears across two pages.
How do i make it appear on only one page?

Thanks.
« Last Edit: August 06, 2009, 05:17:31 pm by cobby »
Logged
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E

danieltennis

  • Guest
Re: Excel Macro
« Reply #3 on: August 28, 2009, 12:26:14 am »
0
Quote from: cobby on August 06, 2009, 05:08:00 pm
found it :P


But when i make the print preview selection, it appears across two pages.
How do i make it appear on only one page?

Thanks.


Change the settings in Page Setup. It should be next to the print button.
Logged

kurrymuncher

  • Guest
Re: Excel Macro
« Reply #4 on: August 28, 2009, 12:28:53 am »
0
Quote from: daniel. on August 28, 2009, 12:26:14 am
Quote from: cobby on August 06, 2009, 05:08:00 pm
found it :P


But when i make the print preview selection, it appears across two pages.
How do i make it appear on only one page?

Thanks.


Change the settings in Page Setup. It should be next to the print button.

a little too late daniel
Logged

methodsboy

  • Guest
Re: Excel Macro
« Reply #5 on: August 31, 2009, 11:46:31 am »
0
^ very late
Logged
Pages: [1]   Go Up