E
Eric White
Instead of "Worksheet" (in the 4th and 5th lines of your
example) you should use "WorksheetS" (note plural "s").
You have to reference the worksheet named "foglio1"
(or "foglio2") in the Worksheets collection.
So:
Set colonna1 = Worksheets("foglio1").Range("b4:b6")
etc.
example) you should use "WorksheetS" (note plural "s").
You have to reference the worksheet named "foglio1"
(or "foglio2") in the Worksheets collection.
So:
Set colonna1 = Worksheets("foglio1").Range("b4:b6")
etc.