Re: $$Excel-Macros$$ am getting compile error

2013-09-10 Thread अनिल नारायण गवली
Dear Prabhu, In place of Sheet2 write Sheets(2).range("A10").value=1000 Warm Regards, Gawli Anil. Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 11:44 AM, De Premor wrote: > Give more attention here ! > > > Sheets("she

Re: $$Excel-Macros$$ am getting compile error

2013-09-10 Thread De Premor
Give more attention here ! /Sheets("//*sheet2*//").Range("A10").Value = 1000// / Because you've specified a sheet name, Please make sure you have Sheet named *sheet2 *in current workbook Pada 11/09/2013 12:22, Prabhu Pinky menulis: Hi experts, Please find below simple codes, while i

RE: $$Excel-Macros$$ am getting compile error

2013-09-10 Thread Ravinder
Its working fine just correct the position of "then of if" From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Wednesday, September 11, 2013 10:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ am getting com

Re: $$Excel-Macros$$ am getting compile error

2013-09-10 Thread अनिल नारायण गवली
Dear Prabhu, Use this code Sub sample() Sheets("sheet2").Range("A10").Value = 1000 Sheets("sheet2").Activate Sheets("sheet2").Range("A10").Select MsgBox "Task Completed" If MsgBox("Do you want to Clear the data ?", vbYesNo, "Confirm") = vbYes Then Range("A:A").ClearContents MsgBox "Data has be

$$Excel-Macros$$ am getting compile error

2013-09-10 Thread Prabhu Pinky
Hi experts, Please find below simple codes, while i run the macro am getting compile error. Please help to know what is the mistake i have done with this code. Sub sample() Sheets("sheet2").Range("A10").Value = 1000 Sheets("sheet2").Activate Sheets("sheet2").Range("A10").Select MsgBox "Task