Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi i'm using the following macro to print a range and add 1 to a cell what i
need it to do is add a number from a cell and then reset to 1, anyone help please Sub Button2_Click() Sheets("Sheet1").Range("E10").Value = _ Sheets("Sheet1").Range("E10").Value + 1 ActiveSheet.Range("Y4:AA12").PrintOut preview:=False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |