Menu

Loop to add +1 in cell?

Search this Thread

Prev

Previous Post

Next Post

Next

#6

Report Post

Posted to microsoft.public.excel.programming

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

Loop to add +1 in cell?

not without another dot

--
Don Guillett
SalesAid Software

"bxvang" wrote in
message ...

Yes, it works perfectly. Thanks!

For reference, here is another code that does the same thing.

Sub add_one()

With Activesheet.Range("A1")
Value = .Value + 1
End With

End Sub

--
bxvang
------------------------------------------------------------------------
bxvang's Profile:
http://www.excelforum.com/member.php...o&userid=35135
View this thread: http://www.excelforum.com/showthread...hreadid=548932

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Loop through last cell/row of used range	tkraju via OfficeKB.com	Excel Discussion (Misc queries)	1	April 4th 09 04:45 PM
how to loop thru cell in 2 columns	DMB	Excel Programming	1	January 10th 06 03:51 PM
Advancing outer Loop Based on criteria of inner loop	ExcelMonkey	Excel Programming	1	August 15th 05 05:23 PM
loop through a cell.	Vincent Jones	Excel Programming	2	June 2nd 04 10:39 PM
get for loop to go on after blank cell?	john_t_h[_12_]	Excel Programming	3	January 15th 04 06:35 AM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement