Increment a variable - ExcelBanter

Posted to microsoft.public.excel.programming

Harry[_3_] Harry[_3_] is offline

external usenet poster

Posts: 1

Increment a variable

Found this on www.mrexcel.com It works great. Excel will do increment on open

In the Workbook module (Or, if its a Userform, in the Initialize event of that Userform) put the following

Private Sub Workbook_Open(
Sheet1.Range("A1") = Sheet1.Range("A1") +
End Su

By Juan Pablo Gonzalez on 25-May-2002

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Runtime Error '91' Object variable or With block variable not set	Alec Coliver	Excel Discussion (Misc queries)	2	October 24th 09 02:29 PM
variable height variable width stacked bar charts	ambthiru	Charts and Charting in Excel	3	January 18th 06 11:41 PM
Sum cells based on a row variable and seperate column variable	CheeseHeadTransplant	Excel Worksheet Functions	10	September 23rd 05 06:59 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Excel Worksheet Functions	1	July 9th 05 03:05 AM
Increment a variable while looping	ibeetb	Excel Programming	2	September 25th 03 07:15 PM

All times are GMT +1. The time now is 10:55 AM.

Menu

About Us