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
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 d...@premor.net wrote:
Give more attention here !
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 Completed
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 been cleared
Else
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
Hi