.Value = .Value + 1
.Offset(0, 1).Value = .Value
Alternative.................use a Spinner from the Forms Toolbar.
Gord Dibben MS Excel MVP
On Mon, 20 Sep 2010 13:54:48 GMT, Bon Mitchell <bish...@hotmail.com> wrote: >can you tell me how to increase value in cell A1 in the same sheet and increase it by 1 then place the new value into A2?
On Tuesday, March 09, 2010 3:58 PM puiuluipui wrote:
Hi, i need a macro to look in sheet 2 column A and look at the last filled >> cell. In the last filled cell i have a number. When i run macro, i need to >> generate (in sheet1 A1) the number from the last filled cell +1.
sheet 2 last filled cell = 29
sheet1 after macro i need to have in A1 = 30
Can this be done?
On Tuesday, March 09, 2010 4:08 PM Mike H wrote:
Yuo can have a macro if you want but you do not need one, try this
When competing hypotheses are otherwise equal, adopt the hypothesis that >>> introduces the fewest assumptions while still sufficiently answering the >>> question.
On Tuesday, March 09, 2010 4:17 PM puiuluipui wrote:
Hi Mike. I really need a macro.
I am using some macros and i need to use this macro along with the other ones.
But i really do not know how to make this work.
Can you help me with a macro?
"Mike H" wrote:
On Tuesday, March 09, 2010 4:26 PM Mike H wrote:
A macro it is then
Dim LastRow As Long
Set SrcSht = Sheets("Sheet2")
Set DstSht = Sheets("Sheet1")
LastRow = SrcSht.Cells(Cells.Rows.Count, "A").End(xlUp).Row
DstSht.Range("A1").Value = SrcSht.Range("A" & LastRow)
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
On Tuesday, March 09, 2010 4:41 PM Lars-?ke Aspelin wrote:
+1 should be added at the end of the last statement like this:
DstSht.Range("A1").Value = SrcSht.Range("A" & LastRow) + 1
On Tuesday, March 09, 2010 4:50 PM puiuluipui wrote:
Hi Mike, your first formula gives me an error, and the macro retrieves the
last number. I need to display last number +1.
Am i doing something wrong?
"Mike H" wrote:
On Tuesday, March 09, 2010 5:30 PM puiuluipui wrote:
it is working.
On Monday, September 20, 2010 9:52 AM Bon Mitchell wrote:
can you tell me how to do that if you want to increase the value inthe same sheet for cells. for example if A1 =1, then the macro will look into A1 and increase it to 2 and place the value into A2.
Submitted via EggHeadCafe - Software Developer Portal of Choice >>>>>>>>> MongoDb vs SQL Server Basic Speed Tests
|Location:||Huddersfield, West Yorkshire, UK|
|Nodes:||16 (2 / 14)|