Muhammad Zain
asked on
Referencing the a fix range of data
Hi guys,
I am working on an excel sheet involving macros. These macros insert certain number of columns to the entire sheet. I want to cell reference the values received from macro to arrange them in an other sheet. Referencing them works for the first time. But when I change some values in the main sheet and re run the macro. my referenced cells moves from their place bcz macro is inserting columns. I want to fix my reference to particular range of data
I am working on an excel sheet involving macros. These macros insert certain number of columns to the entire sheet. I want to cell reference the values received from macro to arrange them in an other sheet. Referencing them works for the first time. But when I change some values in the main sheet and re run the macro. my referenced cells moves from their place bcz macro is inserting columns. I want to fix my reference to particular range of data
An example of the workbook containing the code would help.
ASKER
In the sheet, Macro sheet has a button which will enable my six macros to work in series. in Sheet 3, the values are referred to macro sheet. But if you remove the values of column e on wards. in Macro sheet and press button. My refereed cells will not give me proper value
mysheet.VBA.xlsm
mysheet.VBA.xlsm
The example is VBA protected, but looking at your code you haven't made an comments about what the code should be doing and many of the variables like pyi do not seem to be declared.
I'll have to work through the code to discover what is supposed to be happening
I'll have to work through the code to discover what is supposed to be happening
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have gotten the answer that you need then please close this question. If you don't know how to do that then please see this article.