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
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
Yes, working fine.
Can you please explain me
Birth.Interior.Pattern = xlSolid
PANo.Interior.Pattern = xlSolid
and when we are entering Birthdate using other than "/" it gives error,
instead of debug error, can we put error message.
Regards
On Tue, Sep 10, 2013 at 8:48 PM, De Pr
If you sheet protected by a password, you can add a password on next
statement
Before doing some change on sheet, add this line
ActiveSheet.Unprotect "MySheetPassword"
and after done with it, lock it again by using the same password
ActiveSheet.Protect "MySheetPassword"
Pada 10/09/2013 2
>
> Thank You much De Premor. Very much appreciated
>
--
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. P
Yes got it, but active sheet is password protected, any solution for that.
On Tue, Sep 10, 2013 at 8:29 PM, De Premor wrote:
> If you want to select current sheet, Use* ActiveSheet *to select it,
> not ActiveWorkbook
>
> *ActiveSheet*.Unprotect
>
> bla...bla...bla...
>
> *ActiveSheet*.Protect
If you want to select current sheet, Use*ActiveSheet *to select it, not
ActiveWorkbook
*ActiveSheet*.Unprotect
bla...bla...bla...
*ActiveSheet*.Protect
Pada 10/09/2013 21:52, ITP Abdulgani Shaikh menulis:
Dear Sir,
This sheet is again giving problem, please see attachments. When I am
addi
is it giving you any error
On Tue, Sep 10, 2013 at 2:54 PM, Ravi Kumar wrote:
> Try this and change you folder name accordingly …
>
> ** **
>
> ** **
>
> Sub copy_sheet()
>
> ** **
>
> Application.ScreenUpdating = False
>
> Application.DisplayAlerts = False
>
> ** **
>
> ** **
>
Yess that possible by using VBA, just follow attached workbook
Pada 10/09/2013 20:23, georgebeegl...@gmail.com menulis:
Hi All,
I have say a worksheet that is calculating cells A1:A9 with the Total
being displayed in cell A10
I want the answer of the Sum Function in cell "A10" to be copied to
Hi All,
I have say a worksheet that is calculating cells A1:A9 with the Total being
displayed in cell A10
I want the answer of the Sum Function in cell "A10" to be copied to cell
"A1" in a different worksheet named say "TOTALS"
Easy enough but here is what I want to be able to do:
When the d
Hi Rajan,
Your file is rally awesome and great. I would like to learn this, do you
have any explanatory notes on the functions used in this file so that I
will learn to do this.
On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma wrote:
> Hi Murali,
>
> Chek the attachment too. Might it will also help
--
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,
Try this and change you folder name accordingly .
Sub copy_sheet()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
primewb = ActiveWorkbook.Name
Dim fld As Object, fil As Object, fso As Object
Dim wkb As Workbook
Set fso = CreateObject("scripting.
Thanks for the help but it's not adding my sheet in rest of the workbooks.
i have attached that single sheet & added the macro in it.Please suggest
Where i'm going wrong.
On Monday, September 9, 2013 8:16:20 PM UTC+5:30, ashish wrote:
>
> Sub copy_sheet()
>
> Application.ScreenUpdating = False
Your request should be File, it is best to have one sheet to copy.
2013/9/10 Chih Hung Choo
>
>
> Hi, I'm hoping to get some help here to automate the work that I have to
> do every 2 weeks. The work is repetitive and hopefully a VBA script will
> help shorten sometimes a day's work to minutes
18 matches
Mail list logo