Excel VB not saving chages

[callsidd]

Hi,

can u please also confirm what to do?

 

[Joe4]

You need to provide a bit more details.
Are you talking about changes to the VBA code, or changes that the VBA code makes on the worksheets?
What version of Excel are you using?
What is the extension on the file?

 

[callsidd]

HI, Thanks for your quick reply.

I recorded macros and used offset function in excel 2010. Now whenever I add new sales agent in excel sheet to see their performance, everytime it gives N/A message and when I add them and again run macro, then other agents come as N/A.

I can share that sheet if you give your email id

You need to provide a bit more details.
Are you talking about changes to the VBA code, or changes that the VBA code makes on the worksheets?
What version of Excel are you using?
What is the extension on the file?

 

[Joe4]

I recorded macros and used offset function in excel 2010. Now whenever I add new sales agent in excel sheet to see their performance, everytime it gives N/A message and when I add them and again run macro, then other agents come as N/A.

That seems quite different than your original comments of "Excel VB not saving changes.

You need to do a much better job in explaining your exact issue, including posting your code and explaining exactly what you are doing to cause this issue.

I do not share my email address with people. There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
(Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.)

Some people will also upload their file to a file share site and provide a link here. But realize that many people cannot (or will not) download files from the internet due to security concerns (my workplace actually forbids it).