hello,
Just a quick question, I am trying to write a code, whith an attept to input an if statment. I am trying to write it such that on the if statement it would go to a specific sheet.
Something like
If activecell.value <=0 then
sheetsname = data
Else
sheetsname = data1
end if
sheets(sheetsname).select
Something like that, but its not working.
Thanks for your help
Just a quick question, I am trying to write a code, whith an attept to input an if statment. I am trying to write it such that on the if statement it would go to a specific sheet.
Something like
If activecell.value <=0 then
sheetsname = data
Else
sheetsname = data1
end if
sheets(sheetsname).select
Something like that, but its not working.
Thanks for your help