Hello! I'm new to VBA and this forum, so this may be a simple question but I can't find an example online that works/makes sense to me.
I have a workbook of data and statistics. I'm using these statistics to make a sort of Role Playing Game based around 'XP'. With that being said, the XP should never go down, only up. I'm trying to write a few lines into my 'update' macro that will essentially take their current XP, move it to a neighboring cell, do all of the updates, and compare the new XP to the old amount. If the old amount is higher, it's copied/pasted back.
I have all of the code written for the macro, but I can't seem to figure out how to set the variables the right way (never really set variables) so that I can do that part.
Can you help? Thanks in advance!!
Bookmarks