Forum Discussion
Vincem1377
Oct 20, 2022Copper Contributor
Writing a Macro For When Prining
I am totally new to macros. Have viewed a number of Youtube video but am still totally lost. I have a spreadsheet which prints as 3 pages at a time - page 1of3, 2of3, 3of3. the first 3 rows are...
Nothing_Left_to_Lose
Oct 20, 2022Brass Contributor
Maybe something like this...
'---
Sub PrintSomething()
Dim N As Long
For N = 1 To 10
Range("C3").Value = "00" & N
ActiveSheet.PrintOut
Next
End Sub
'---
Nothing Left to Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)
Vincem1377
Oct 21, 2022Copper Contributor
Thank you! looking to try it out. Cheers
- Nothing_Left_to_LoseOct 24, 2022Brass ContributorTo: Vincem1377
Did the code work for you?
'---
Nothing Left To Lose