If statement

[Guest]

Hello,

Could you help me to use my worksheets in a VBA if
statements. I am getting an error when I try to this way

If activesheet = ("sheet") then
......
Else
......
....
Endif

How can I do this?

Thank You

 

[Frank Kabel]

Hi
may be something like
if Activesheet.name = "your_sheetname" then
....

 

[Don Guillett]

how about
if activesheet=sheets("sheet1") then
do this
else
do that
end if

 

[Guest]

Thanks, that works

-----Original Message-----
Hi
may be something like
if Activesheet.name = "your_sheetname" then
....

--
Regards
Frank Kabel
Frankfurt, Germany



.