I am working with VBA and Excel. I have a table in excel which follows a VBA code. I have noticed that when I change the headings in my table, the code gets an Error sign. How do I make it so that I can change the heading, and the code can still run successfully?
2007-07-19 22:30:04 · 2 answers · asked by aashish1989 3 in Computers & Internet ➔ Programming & Design
Depends on your code and without looking at your code its hard to say exactly...
The VBA may be executing every time the sheet is opened or loaded. Add code to only create the table if the sheet is initially blank.
Your code maybe looking for a specific text string in a heading so by changing it the code cannot find the heading.
If you are loading numbers into a table starting at the first row try starting at row 2 and leave a blank row at the top for your heading.
You can always use another sheet and copy the table values onto it (Paste special) this will break the connection between the table results and the code allowing you to do whatever you want. It also breaks any updating of the copied table information.
2007-07-20 01:53:15 · answer #1 · answered by MarkG 7 · 0⤊ 1⤋
Does not look trivial, may be you can contact a VB expert. Check websites like http://getafreelnacer.com/
2007-07-20 03:08:42 · answer #2 · answered by Anonymous · 0⤊ 1⤋