I presume I need a macro

[DannyBoy2k]

As noted, I assume I'll need a macro, but I have no clue about them, so I'd be VERY grateful for any answer.

Anyways. I have a named range, running from B3 through to BG91. In this space, I need to find some way to add 1 into specific cells.
There are labels running the length and depth, and I know how to specify one particular cell, using two lists, one for each. This allows me
to specify one particular "X/Y" co-ordinate. However, getting excel to return a specific cell, and its content, isn't really the point.
I need to be able to write to that specific cell. All I need is for it to add +1 to the result already there, but I can't find a way to.

Now, sure, I could just go in, find that cell, and add to it. But by the 50th time, that gets tedious, even without the hassle of making sure you're
in the right place.

The reason for this is that I, later, am aiming to make a bunch of dynamic charts, which would then change depending on the value given over both the entire range, and sub-sets of it.

So, anyone that can help me find a way to add +1 where I specify, without me having to go hunt the place down each time?
I am using Excel 2007, I should specify.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[DannyBoy2k]

So what, then, would you put as a description? Considering that I know ****-all about macros, the description would be longer than the post.
But no matter, it isn't relevant. After all, much like every other similar forum purporting to be meant to help, this place is
more interested in being assholes in response than being helpful. Bravo.

[Gatti]

Oh wow... can't follow the rules and curse the forum

Cool!

[FDibbins]

DannyBoy, in the unlikely event that you will read this...we all have rules that everyone needs to abide by. We insist on descriptive thread titles because many people - and not just members - search on key words. I doubt anyone would search for their specific requirements based on your title?

As for what you could use? You already said what you wanted in your 2nd paragraph...

(how to ) add 1 into specific cells