Hi,
in sheet2 i have some cells which are update dynamically, and in sheet3 i have a chart which is updated by values that are in sheet2
everything works good if i'm on sheet2 (sheet2 active)
but if i click on sheet3 and i wait for the IF case i've got an error.
why?
local Variable
in sheet2 i have some cells which are update dynamically, and in sheet3 i have a chart which is updated by values that are in sheet2
everything works good if i'm on sheet2 (sheet2 active)
but if i click on sheet3 and i wait for the IF case i've got an error.
why?
local Variable
pIndex contains A after a while B and so on...Sub macro1()
Dim pIndex As String
I have no problem also if i'm in another sheet that is not a chart...
If WorksheetFunction.CountA(Sheets("Sheet2").Columns(pIndex)) > 1
Last edited: