1

I have a workbook with 4 sheets. The 4 sheets are almost identical Some of the cells values are calculated by calling a macro in the cell. For the active worksheet this Works fint. The macro gets all the values from the correct sheet and the calculation is correct. But, when the calculation is done in the active worksheet the cells in all the worksheet that calls the macro is changed with the value calculated in the active worksheet.

How do I make sure that only the cells in the active workseet that calls the macro is changed?

[EDIT]

Example:

I have 2 sheets. In both sheets I have a cell that calls a function: .Value = "=FunctionName()"

When I do calculations in sheet 1, the cell with the call is showing correct result. But the cell in sheet 2 is showing the same result.

Only the cell in sheet 1 should show the result from the function calculated from sheet 1.

Jim
  • 995
  • 2
  • 11
  • 28
  • 1
    See [With ... End With statement](https://msdn.microsoft.com/en-us/library/wc500chb.aspx) and [How to avoid using Select in Excel VBA macros](http://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba-macros). If you get around to posting some code we could likely help you with that. Do you have any UDFs? –  Feb 16 '16 at 09:46

1 Answers1

0

Say if you want to change in sheet1. Then

Worksheets("Sheet1").Activate
With ActiveWorksheet
Call calculationsmacro     'your macro to calculate the cells
End With

I had kind of similar problem and it was solved by this method. If it works for you then it would be really grateful if you can mark my answer.

Neha
  • 50
  • 10