Hi Susan,
Not sure if this is the problem, but I thought I'd mention it;
When using a sheet name, the syntax is:
Worksheets("Base Scenario") or just Sheets("Base Scenario")
But when using the sheet number, neither quotes, nor the word 'Sheet' are not
used inside the brackets.
So it just becomes:
**
*Suggestion:* Make the sheet's name dynamic in macro.
you can do something like this:
When you are on the sheet from where formula range has to be taken, use this
code, this will give you name of the sheet:
*shtname = Activesheet.Name*
Now when you are on the destination sheet, use this code,
Have a macro to refresh a formula, however, if the sheet named Base
Scenario gets renamed, It won't change the macro. If I replace
the"Base Scenario" reference in the macro's parenthesis with
"Sheet12", (Sheet12 is its reference before the name change) it
creates a #REF error. Any thoughts? Than
Dear members,
Hope you all are doing well !!
I am quite happy to see that you are submitting very good ideas and
suggestions in this initiative but the participation is NOT enough.
I encourage you all to submit atleast one idea in this initiative. This is
very good tool to submit the idea and
can you attach the sample workbook
On Tue, Dec 14, 2010 at 4:25 PM, Priya Jose wrote:
> Dear All,
>
> This below is one of the TOUGHEST one to solve, appreciate your review and
> feedback.
>
> A format needs to be prepared wherein for a task to accomplish you have
> following status:
>
>
>
> 1)
Hi All,
I have recorded the below coding, when i try to ran this macro and it is
showing error. The data keep varies on and please help me to rectify the
error.
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"GCF Directors rpt!R1C1:R6090C7", Version:=xlPivotTab
Dear All,
This below is one of the TOUGHEST one to solve, appreciate your review and
feedback.
A format needs to be prepared wherein for a task to accomplish you have
following status:
1) Done
:Completed.
2) Pending
: Not done within the given time frame.
check this link
http://www.contextures.com/xldataval13.html#Create
On Tue, Dec 14, 2010 at 11:32 AM, lucky singh wrote:
>
> Hi All,
>
> need your help on validation
>
> if i select softdiet then only the menu of soft diet should be shown in
> dropdown & not hard diet similarly to hard diet on h
try this
INDEX($B$1:$W$1,0,MATCH("Collected",B2:W2,0))
On Tue, Dec 14, 2010 at 11:28 AM, lucky singh wrote:
> Hi All,
>
> kindly help me to get the collaction date with the help of an formula...
> I want to know the date of collection of each customer...
>
> please refer the attachment...
>
>
>
check this link see if it helps
http://www.ehow.com/how_5976974_insert-flash-movie-outlook-signature.html
On Tue, Dec 14, 2010 at 10:44 AM, renuka chari wrote:
> hi experts good morning
> i need help for insert flash(.swf) signature file into outlook
> signature
> how it possible can u help me
Dear All Group Member, Kind Attn- Mr. Ayush Jain,
I need a excel macro book for start to bottom level creating macro,
preparing interview skill & help VB also.
Please suggest.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Sat, Dec 11, 2010 at 1:39 PM, Ayush wrote:
> Hi Pete,
>
> No Qu
Hi All,
need your help on validation
if i select softdiet then only the menu of soft diet should be shown in
dropdown & not hard diet similarly to hard diet on hard diet should be shown
in dropdown & not soft diet...
Regards,
Lucky
--
--
Thanx vaibhav it was impossible for me...
Regards,
Lucky
On Mon, Dec 13, 2010 at 9:45 PM, in.vaib...@googlemail.com <
in.vaib...@gmail.com> wrote:
> Try This,
>
>
> http://www.signaturebar.com/> http://www.signaturebar.com/uploads/images/24667.png border=0>
>
>
> On Mon, Dec 13, 2010 at 9:37 P
hi experts good morning
i need help for insert flash(.swf) signature file into outlook
signature
how it possible can u help me pl
thanks in advance
--
--
Some important links for excel users:
1. Follow us on TWIT
14 matches
Mail list logo