Macro to Increment a Cell Value by One

[Puppies72]

Hi all,

I need a macro (which I can assign to a button) to increment the values in a range of cells from AD4:AD204 by 1 but only if the cell is not empty.

Basically I am updating a sheet and some of the cells in that range will be empty until I add data so when I click on my "Update Sheet" button it will increment the values by one for cells with data in and then when I add new data and update those cells will begin their incrementation.

Hope that makes sense

thanks in advance!!

 

[Jon von der Heyden]

Hi

It works for me but please make sure that you amend your array of sheet names to the exact names of the sheets that you want this to process. Make sure no typo's, make sure they are included in quotes.

Please also make sure that you added this to the module in the correct workbook / project. I suspect you may have added it to the wrong one (and perhaps that one is disabled).

 

[Puppies72]

100% correct as usual Jon I was trying to put the macro in the wrong part!

thanks again guys

 

[itommy14]

[h=2]macro to increment a cell value by one, but in another sheet[/h]if A1 in sheet 1 is selected I want to press button (who i assigned the macro) and cell B2 in sheet 2 (for example) increase by one
How can I do?