Hi

you need to declare the variable at the top of the module sheet
Dim sheet_name as String
if all of the code is in the same module sheet.

If it isn't you need to declare the variable as
Public sheet_name as String
at the top of a module sheet

Hope this helps
Cheers
JulieD

"anang" wrote in message
om...
I have little problem with my macro. How to assign the value of the
variable to other macro which I call in main macro.

Sub Macro1()
sheet_name = "Measurement 1"
Call Looping
Call Positifing
End Sub

I have "sheet_name" variable inside the Looping and Positifing macros
.