
ofer moshe
Member
Members

Forum Posts: 8
Member Since:
August 5, 2022
August 5, 2022

Hello VBA cannons
I have a report in cell A1 the date
I want to print a number of reports that each time the date will be increased by a day.
Or a second option to write from date to date for example: 1/8/22-15/8/22
And I will print everything and each printing will cost a day?
Thanks

Catalin Bombea
Iasi, Romania
Admin

Forum Posts: 1824
Member Since:
November 8, 2013
November 8, 2013

Simply use this code in a standard vba module:
Sub PrintSheet()
ActiveSheet.PrintOut
ActiveSheet.Range("A1").Value=ActiveSheet.Range("A1").Value+1
End Sub
In the sheet you want to print, insert any shape, then right click that shape, click on Assign Macros and assign the PrintSheet macro you just added.

Jessica Stewart
Northern USA
Member
Members

Trusted Members

Trusted Members

Forum Posts: 218
Member Since:
February 13, 2021
February 13, 2021

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Bright Asamoah
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Gilbert Lemek
Ashleigh Farquharson
Jayz Luu
Fred Smith
Charles DeGraffenreaid
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Forum Stats:
Groups: 3
Forums: 24
Topics: 6360
Posts: 27812
Member Stats:
Guest Posters: 49
Members: 32340
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
