jl2509
Board Regular
- Joined
- Oct 30, 2015
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
Hi All,
I have an order form setup on a worksheet that is copied using VBA
At the top of the form in cell "B1", there is Text set as "Order #1 " this number representing the number of the order form.
When I generate a new form using the code already in place, how can I get the text in cell "B1" to increment by 1 from the previous form number. The previous number is always in cell "M1"
Appreciate the help
I have an order form setup on a worksheet that is copied using VBA
At the top of the form in cell "B1", there is Text set as "Order #1 " this number representing the number of the order form.
When I generate a new form using the code already in place, how can I get the text in cell "B1" to increment by 1 from the previous form number. The previous number is always in cell "M1"
Appreciate the help