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
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
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 compile error
H
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
