Go Back   Computer Juice > Computer Software > Office Suites & Applications
Register iSpy Downloads New Posts Donate Unanswered Posts Member List Search

Computer Juice raffle - Win PC hardware of your choice worth 500 / 680 / $1000 - Enter HERE!


Computer Juice - Forums - Print Macro


Reply
 
LinkBack Thread Tools
  #1  
Old 01-03-2008, 12:42 PM
No Avatar
Dj Ram  United Kingdom
CJ New Member
 
Dj Ram is offline
 
Join Date: Feb 2008
Last Online: 08-03-2008 12:35 PM
Posts: 8
iTrader: (0)
Dj Ram is on a distinguished road
Default

Print Macro


I need to know how to create a macro so that when i press a command button a wrksheet will print two copies of the cell range.

Thanks
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #2  
Old 01-03-2008, 12:48 PM
spot's Avatar
spot  Wales
CJ Donator
Intel Nvidia
spot is offline
 
Join Date: Feb 2008
Last Online: 29-06-2008 04:34 PM
Posts: 525
iTrader: (0)
spot is on a distinguished roadspot is on a distinguished road
Default

Print Macro


Have you selected a spreadsheet program to do this in yet?
__________________

My System: Tim

CPU(s):
Athlon 64 3500+
Motherboard:
Asus A8N-VM CSM
RAM:
Corsair PC3200 CL2 DDR-400 2GB
Graphics Card(s):
nVidia Geforce 6600 512MB
Sound Card:
Cherry RS 6000 M keyboard
Hard Drive(s):
Barracuda.7+ 2x200GB 58MB/s sustained
Optical Drive(s):
Samsung DVD-ROM TS-H352
Case / PSU:
Thermaltake Soprano
Cooling:
Stock
Network / Internet:
Telewest 2x20Mb/sec
Monitor(s):
SXGA flat panel
Operating System(s):
Slackware (2.6.24.3) (Fluxbox) (bash)

Want your system info in your signature?
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #3  
Old 01-03-2008, 12:49 PM
No Avatar
Dj Ram  United Kingdom
CJ New Member
 
Dj Ram is offline
 
Join Date: Feb 2008
Last Online: 08-03-2008 12:35 PM
Posts: 8
iTrader: (0)
Dj Ram is on a distinguished road
Default

Print Macro


yeh sorry its in excel
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #4  
Old 01-03-2008, 01:03 PM
spot's Avatar
spot  Wales
CJ Donator
Intel Nvidia
spot is offline
 
Join Date: Feb 2008
Last Online: 29-06-2008 04:34 PM
Posts: 525
iTrader: (0)
spot is on a distinguished roadspot is on a distinguished road
Default

Print Macro


Any particular version of excel? I hate to be pushy but.
__________________

My System: Tim

CPU(s):
Athlon 64 3500+
Motherboard:
Asus A8N-VM CSM
RAM:
Corsair PC3200 CL2 DDR-400 2GB
Graphics Card(s):
nVidia Geforce 6600 512MB
Sound Card:
Cherry RS 6000 M keyboard
Hard Drive(s):
Barracuda.7+ 2x200GB 58MB/s sustained
Optical Drive(s):
Samsung DVD-ROM TS-H352
Case / PSU:
Thermaltake Soprano
Cooling:
Stock
Network / Internet:
Telewest 2x20Mb/sec
Monitor(s):
SXGA flat panel
Operating System(s):
Slackware (2.6.24.3) (Fluxbox) (bash)

Want your system info in your signature?
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #5  
Old 01-03-2008, 01:27 PM
No Avatar
Dj Ram  United Kingdom
CJ New Member
 
Dj Ram is offline
 
Join Date: Feb 2008
Last Online: 08-03-2008 12:35 PM
Posts: 8
iTrader: (0)
Dj Ram is on a distinguished road
Default

Print Macro


well at home im usin 2007, but im out atm so im usin 2003 where i am atm
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #6  
Old 01-03-2008, 01:31 PM
spot's Avatar
spot  Wales
CJ Donator
Intel Nvidia
spot is offline
 
Join Date: Feb 2008
Last Online: 29-06-2008 04:34 PM
Posts: 525
iTrader: (0)
spot is on a distinguished roadspot is on a distinguished road
Default

Print Macro


okay, this ought to work on both.

Sub PrintRange()
'
' PrintRange Macro
' This will print 2 copies of a worksheet preselected range
'
Application.ScreenUpdating = False
Sheets("Sheet1").Select
ActiveSheet.Unprotect
ActiveWindow.Range("C5:D17").PrintOut Copies:=2
Application.ScreenUpdating = True
End Sub

If you have trouble creating a button or hooking the code to it then say and we'll talk you through it.
__________________

My System: Tim

CPU(s):
Athlon 64 3500+
Motherboard:
Asus A8N-VM CSM
RAM:
Corsair PC3200 CL2 DDR-400 2GB
Graphics Card(s):
nVidia Geforce 6600 512MB
Sound Card:
Cherry RS 6000 M keyboard
Hard Drive(s):
Barracuda.7+ 2x200GB 58MB/s sustained
Optical Drive(s):
Samsung DVD-ROM TS-H352
Case / PSU:
Thermaltake Soprano
Cooling:
Stock
Network / Internet:
Telewest 2x20Mb/sec
Monitor(s):
SXGA flat panel
Operating System(s):
Slackware (2.6.24.3) (Fluxbox) (bash)

Want your system info in your signature?
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #7  
Old 08-03-2008, 11:35 AM
No Avatar
Dj Ram  United Kingdom
CJ New Member
 
Dj Ram is offline
 
Join Date: Feb 2008
Last Online: 08-03-2008 12:35 PM
Posts: 8
iTrader: (0)
Dj Ram is on a distinguished road
Default

Print Macro


Sorry for a delayed response. Thanks I will try this and will give you feedback as soon as possible :)
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #8  
Old 08-03-2008, 12:03 PM
spot's Avatar
spot  Wales
CJ Donator
Intel Nvidia
spot is offline
 
Join Date: Feb 2008
Last Online: 29-06-2008 04:34 PM
Posts: 525
iTrader: (0)
spot is on a distinguished roadspot is on a distinguished road
Default

Print Macro


What's in that example is fairly random, I've no idea whether you've multiple sheets or you've protected areas or you want to end up somewhere different after the macro's run than where you were when you clicked it. Or whether your worksheet range is based on labels or on hard cell addresses. I suggest you play with the syntax a bit, the line that does all the work is

ActiveWindow.Range("C5:D17").PrintOut Copies:=2

and you can change that to your heart's content.
__________________

My System: Tim

CPU(s):
Athlon 64 3500+
Motherboard:
Asus A8N-VM CSM
RAM:
Corsair PC3200 CL2 DDR-400 2GB
Graphics Card(s):
nVidia Geforce 6600 512MB
Sound Card:
Cherry RS 6000 M keyboard
Hard Drive(s):
Barracuda.7+ 2x200GB 58MB/s sustained
Optical Drive(s):
Samsung DVD-ROM TS-H352
Case / PSU:
Thermaltake Soprano
Cooling:
Stock
Network / Internet:
Telewest 2x20Mb/sec
Monitor(s):
SXGA flat panel
Operating System(s):
Slackware (2.6.24.3) (Fluxbox) (bash)

Want your system info in your signature?
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote
  #9  
Old 08-03-2008, 12:36 PM
No Avatar
Dj Ram  United Kingdom
CJ New Member
 
Dj Ram is offline
 
Join Date: Feb 2008
Last Online: 08-03-2008 12:35 PM
Posts: 8
iTrader: (0)
Dj Ram is on a distinguished road
Default

Print Macro


Thanks for the help guys... I have done it now.
Digg this postDel.icio.us this postTechnorati this postNetscape this postStumble this post
Reply With Quote

Please support this forum, donate towards our running costs.


Reply



Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Screen function VJH Digital Imaging & Printers 7 07-12-2007 08:49 AM
When I try to print something off my computer... whattheheck Multimedia, Drivers & Codecs 3 23-04-2007 12:04 AM
can you print on a transparency using... big bike biker Digital Imaging & Printers 1 31-03-2007 10:40 PM
Digital camera question... digital macro? Gertrude Digital Imaging & Printers 1 31-03-2007 03:05 PM
The print size and color in YIM won't stay as I set it. 知道 wo zhi dao Email, VoIP & IM Discussion 1 19-03-2007 12:00 AM



Copyright 2006 - 2008 Computer Juice - Forums - Free PC Help, Support and Repairs.

Powered by vBulletin® Copyright ©2000 - 2008 Jelsoft Enterprises Ltd. SEO by vBSEO ©2007, Crawlability, Inc.