$$Excel-Macros$$ Not able to change background color

Hi all I need to change the color of a cell through Macro using following code === Sub Main End Sub Function Change_Color() ActiveCell.Interior.ColorIndex = 36 End Function That throws run time error 'Object is not set' Can any one suggest

$$Excel-Macros$$ Re: Not able to change background color

Hi Anil Thanks for ur help But I do not have much knowledge about macros as I have just started working on it. can you explain little bit more as an I need to do something with code or else for Selection change event On Wednesday, March 6, 2013 12:34:38 PM UTC+5:30,

Re: $$Excel-Macros$$ Re: Not able to change background color

Thanks Anil for that much help But still when I run your defined macro 'Sheet3' it change nothing. I also try to call that function using '=Sheet3()' but not working Am I wrong in calling that function On Wednesday, March 6, 2013 4:23:02 PM UTC+5:30, अनिल नारायण गवली wrote: Dear Anu,