Incrementing a cell value by 1 within a running macro [SOLVED]

[Cammandk]

I have a macro that runs and as part of it I need to increment a cell by 1.

Thought going to the cell as part of the macro record and +1 in the cell would do it but no success yet.

 

[SirJB7]

Hi, Cammandak!


Wow... it's your 4th started topic today... I'd suggest you to take a few minutes break and go thru the green sticky posts at this forums main page.

If you had done so you should have noticed interesting and useful things like this:


"How to get the Best Results


Use Relevant words in the Title and in the tag Box, This will aid future searches.

When drafting a question, try and lay out the question in a clear and concise way.

Try and tell the readers what is the situation, what have you tried and what do you want to achieve.

Don't leave out information more info is better

For the best/fastest results, Upload a Sample File."


Now I'm wondering how do you expect that someone could help you with the information provided in your starting post.


Regards!


PS: Bold is mine.

 

[NARAYANK991]

Hi ,


Having the following statement will do it :


[A1] = Val([A1]) + 1


will increment the contents of A1 by 1.


Narayan

 

[Cammandk]

Hi,

Thanks for advice - just super keen at moment and people been so helpful but will look at postings.

What triggers the statement.

The macro I am running is a one time end of month and at that time I need the value to increase.

Where is this statement placed


Cammandk

 

[NARAYANK991]

Hi ,


Put it within your macro ; only don't put it within any loop , since you want it executed just once every time you run the macro.


Narayan

 

[Cammandk]

Thanks - Got working.

SOLVED