How to create macros for daily updated of data

[vikas1317]

Hi ,


i am working as MIS spock n now learning to create macros and learn some new but issue is when i am trying prepared new macros but it is not runing

 

[oldbrewer]

no idea what you are asking - sorry
what is MIS
what is spock

arfe you saying you have written a macro, but it will not run ?

 

[ranman256]

1. you must turn on macros, in excel, options, trust center, trust center settings, macro settings: ENAble ALL MACROS.
otherwise they will not run unless you enable it every time.
or
2. step 1 is enabled and your macro is broken.

 

[oldbrewer]

try this macro

cells(1,1)="hello"
end sub