subject:"Re\: $$Excel\-Macros$$ am getting compile error"

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("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 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"
> if msgbox("Do you want to Clear the data ?",vbYesNo,"Confirm")= vbYes
> then
> Range("A:A").ClearContents
> MsgBox "Data has been cleared"
> Else
> MsgBox "Data has not been cleared"
> End If
> End Sub
>
>
>
> Thanks & Regards,
> Prabhu R
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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 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"
if msgbox("Do you want to Clear the data ?",vbYesNo,"Confirm")= vbYes
then
Range("A:A").ClearContents
MsgBox "Data has been cleared"
Else
MsgBox "Data has not been cleared"
End If
End Sub



Thanks & Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like 
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners 
and members are not responsible for any loss.

---
You received this message because you are subscribed to the Google 
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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"

if msgbox("Do you want to Clear the data ?",vbYesNo,"Confirm")= vbYes then

Range("A:A").ClearContents

MsgBox "Data has been cleared"

Else

MsgBox "Data has not been cleared"

End If

End Sub

Thanks & Regards,
Prabhu R

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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 been cleared"
Else
MsgBox "Data has not been cleared"
End If
End Sub

Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd


On Wed, Sep 11, 2013 at 10:52 AM, Prabhu Pinky  wrote:
> 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"
> if msgbox("Do you want to Clear the data ?",vbYesNo,"Confirm")= vbYes
> then
> Range("A:A").ClearContents
> MsgBox "Data has been cleared"
> Else
> MsgBox "Data has not been cleared"
> End If
> End Sub
>
>
>
> Thanks & Regards,
> Prabhu R
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

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

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

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

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

4 matches

Site Navigation

Mail list logo

Footer information