How to define worksheet (active worksheet will also do)

[ThrottleWorks]

Hi,


I am trying to define a worksheet, but I am geting a bug.


I am using following line


Dim Data as worksheet

set Data = activeworksheet


I am getting Run Time Error 424

Object Required.


I have checked the sheet name, it is correct, I know I am making some silly mistake.


Can anyone help me in this please.

 

[NARAYANK991]

Hi Sachin ,


The keyword is Activesheet , not Activeworksheet.


Narayan

 

[ThrottleWorks]

Hi Narayan Sir, thanks a lot for the help, this is working.


Have a nice day.