please help with stamping cells

[Luis939]

This is a biggie, what i mean is simple, is there any method of running my macro, and somehow stamping cells or letting my program know that values from a cell have been added to another. My whole program is based on transfering and adding numbers, ill assign the value of one cell to a variable, and then have a cell from another workbook equal that variable plus its existing value, so basically i dont want to run the macro again on the same worksheets, and have the same numbers being added to the file. The reason for this is because if there is an error somewhere in the middle of the program, i dont want the users to have to erase everything and start all over again, i just want the program to sort of "remember" the numbers it has put in so far and then just continue to put in the other numbers from where the program errored whenever i run the macro again, thanks i hope i was understandable, thanks alot!!!

 

[SkipVought]

Hi,
Why don't you set up a phantom invisible sheet where you can record your progress. If you have to restart the procedure, then you first scan the phantom sheet to see where you might have left off. When you are done, you just delete the sheet.

VOLA! ;-)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Luis939]

hmmm well even though i never thought of that, its more complicated than that, see my macro works with puttin numbers from more than one worksheet in a workbook to another workbook, so I would also have to somehow record which worksheets in the first workbook had its numbers completely transfered so that i dotn transfer over the same numbers again, thinkin bout it makes me think thats not really possible

 

[Luis939]

but still how would i do what u said, just tell it to create a new workbook and then copy over my values??

 

[SkipVought]

1. Use a convention for naming the phantom sheets
2. test to see if phantom sheet(s) exist for the sheet(s) that you are updating -- if not insert a new sheet using your convention
3. update the sheet(s) and phantom(s) with data values
4. when you're done, delete the phantom(s)

Programming is alot of tedious stuff.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Luis939]

ok ill try that, thanks for the idea, do u think u can help me with my next thread, ill repost it now, i think people missed it since i posted it so early in the morning thanks!