Amending code based on cell value

**excellentexcel** · 06-27-2009, 08:35 AM

hi guys
im a little bit stuck i have this code ( straight forward enough )

HTML Code:

but i would like the line completion sheet to printout copies based on whats in cell h12 of working sheet

so if h12 has a 3 in it it prints out 3 copies

is this possible?
thanks in advance

**mudraker** · 06-27-2009, 08:42 AM

I was not sure what you meant by working sheet so I have assumed it is the sheet name

Sheets("Completion sheet").PrintOut Copies:=Sheets("working sheet").Range("h12").Value

If it is the Active sheet then change

Sheets("working sheet")

to

Activesheet

**excellentexcel** · 06-27-2009, 08:47 AM

hi mudraker

working sheet is the sheet all the data is put into
ie name
address
etc etc

and then i have a sheet called completion sheet which would need to print the number of copies based on cell h12 in working sheet
i thnk that will be your top answer

thanks

**excellentexcel** · 06-27-2009, 09:09 AM

hi mudraker
its not doing as id hoped
i have attached it

so if cell h12 ( in yellow) has 3 in it i need it to print 3 copies of completionsheet and if it says 20 it needs to print 20

thanks for your help

**martindwilson** · 06-27-2009, 08:45 AM

Sheets("sheet1").PrintOut Copies:=Range("h12").Value

**martindwilson** · 06-27-2009, 09:21 AM

doesnt it have to be an xlsm?

**excellentexcel** · 06-27-2009, 12:28 PM

Hi martin
the workbook has several other macros in it
so i guess it does

**excellentexcel** · 06-27-2009, 12:36 PM

here is the trial as a xlsm

**excellentexcel** · 06-27-2009, 01:04 PM

think this should be in programming if a mod would be kind enough to move it for me

**martindwilson** · 06-27-2009, 01:10 PM

that code works fine i assigned button one to Sub Button1_Click() macro and away it went

**excellentexcel** · 06-27-2009, 01:25 PM

maybe i need to try it at work as my printers isnt working so im checking the print queue and it says 1 page

**martindwilson** · 06-27-2009, 01:29 PM

ps i now have several sheets with just "hello" on if anyone wants them lol

**excellentexcel** · 06-27-2009, 01:34 PM

lol thanks martin
so if you change it to just 1 it only prints one copy?

Originally Posted by martindwilson

ps i now have several sheets with just "hello" on if anyone wants them lol

**martindwilson** · 06-27-2009, 01:38 PM

yep
ps i now have another sheet with hello on it!!!!!!!

Amending code based on cell value

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

re: Amending code based on cell value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions