Many congratulations Ashish. Keep up the helping spirit. Best of luck.
Regards,
DILIPandey
On 6/2/11, Ayush Jain wrote:
> Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> May'11
> He has posted 67 posts in May 2011 and helped many people through his
You are welcome Bob :)
Best Regards,
DILIPandey
On 6/3/11, Bob wrote:
> Thank you so much for your help!!! That got it!
>
> On Jun 1, 2:14 am, Dilip Pandey wrote:
>> Hi Bob,
>>
>> I am not sure how many rows you have, hence came up with following:-
>> Sub dkp()
>>
>> For i = 1 To Range("b65536"
Sorry dear but I'm unable to understand. Can you please explain it?
Thnx
*---
кαяαηη*
On Fri, Jun 3, 2011 at 12:25 AM, abdelrahman noaman <
abdelrahman.go...@gmail.com> wrote:
> Hi All It is very esey just go to excel option and disabl the macro and
> check dont trust all vba cod and pass
It worked perfectly:), 1000 thanks Mahesh
2011/6/1 Mahesh parab
> Hi
>
> Try :
>
> Sub Test()
> Dim ws As Worksheet
> Sheets("Brands").Select
> Sheets("Brands").UsedRange.Copy
> Windows("Comparsheet.xls").Activate
> For Each ws In Worksheets
> If ws.UsedRange.Cells.Count < 1 Then ws.Delete
>
Hi All It is very esey just go to excel option and disabl the macro and
check dont trust all vba cod and passwrod request will not work than sheet
will open and go to refrance pswlist and you will show all pass and than go
to vba auditor and show code and user form
thx and best wishes
gomaa.
On 2
Hello Everyone,
Ashish Koul has been selected as 'Most Helpful Member' for the month of
May'11
He has posted 67 posts in May 2011 and helped many people through his
expertise. He has been consistent contributor to this excel forum and
achieved this recognition from last six months consecutively.T
Vasant,I'm seeking help to write a macro.
On Thu, Jun 2, 2011 at 12:23 AM, Vasant wrote:
> A crude way of doing it is using the indirect function (though not
> advisable), on condition that the file name is updated in C13 cell and file
> is open.
> Generally Indirect is not used outside a workbo
Thnx a lot Rajan. You are most helpful persongreat... :)
*---
кαяαηη*
On Thu, Jun 2, 2011 at 5:37 PM, Rajan_Verma wrote:
> Hi Karan,
>
> I think it has been Complete Now….
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *karan 1237
>
Thnx a lot Rajan but I want one more thing that is it possible to make input
box character like dis *. If it is possible so please help.
Thnx
*---
кαяαηη*
On Thu, Jun 2, 2011 at 11:59 AM, Rajan_Verma wrote:
> HI Karan
>
> See it help
>
>
>
> Rajan
>
>
>
> *From:* excel-macros@googleg
Hi
See the attached file
apply pivot table on the data, like what i have done & see the grand total.
which have 3 in subtotal that is the person you want.
Regards,
Deepak
On Thu, Jun 2, 2011 at 10:17 AM, Rajan_Verma wrote:
> See if it help
>
> -Original Message-
> From: excel-macros@g
Thanks, this helps.
regards,
Amith
On May 30, 10:05 pm, Dilip Pandey wrote:
> Hi Amith,
>
> See the attached file.
> Let me know in case of any queries.
>
> Best Regards,
> DILIPandey
>
> On 5/27/11, Jhoomla wrote:
>
>
>
> > Does any one have a function or formula to extract for a path for
> >
A crude way of doing it is using the indirect function (though not
advisable), on condition that the file name is updated in C13 cell and file
is open.
Generally Indirect is not used outside a workbook
=SUM(prod!J2:J9)-SUM(INDIRECT("["&C13&"]prod!$I$2:$I$9"))
The other way round is writing a macr
Thnx for this vishal but I dnt wnt to prtect sheet as you think I want to
protect sheet in different way. I hope you'v seen that excel file which I'v
attached. I made a combo box & I want to protect it like : I chose a name
from combobox like Dharmendra mishra & now I want that when I choose name
13 matches
Mail list logo
