Hi Ashish,
Thanks for the help. I do not want to loop this. In real time it would be
only one lot at a time. Also the sample sheet contains identical lot list,
whereas in my real sheet the main sheet has ~3000 entries. So the macro
should look only for one lot at a time. This lot will be st
Private Sub CommandButton1_Click()
MsgBox "hi"
End Sub
Private Sub CommandButton2_Click()
Application.OnTime Now() + TimeValue("00:00:05"),
"Sheet1.CommandButton1_Click" ' It works
'Application.OnTime Now() + TimeValue("00:00:05"),
"Sheets('Test')!CommandButton1_Click"' It fails.
Be,
Its not what i am looking for. Thanks for your respone.
On Mon, Mar 11, 2013 at 12:14 AM, Bé Trần Văn wrote:
> Use CommandButton1_Click to select sheet
> Code:
>
> Private Sub CommandButton1_Click()
> Sheets("TTLongThanh").Select
> End Sub
> See Attachment
> 2013/3/11 Santosh V
>
>> Privat
Hi Ashish!
thanks for your valuble replay,
this formula was fulfilling my requirement a little. Please suggest much
better output.
thanks
On Sunday, 10 March 2013 12:06:55 UTC+5:30, ashish wrote:
> Try this formula see if it suffice ur requirement
>
> *
> =HYPERLINK("#'"&B$1&"'!a"&M
i mean that is there any way to searched result cell should be appear in
the top of the page while clicking the cell.
but your formula result was appearing in the bottom of the page.
and i don,t want to show the formula in the cell. i am expecting VBA code
for that.
but anyway your answer is
If anyone can help me on this.
On Fri, Mar 8, 2013 at 12:41 PM, Amit Gandhi wrote:
> Thanks Ashish. Good work.
>
> But this UDF doesn't satisfy Criteria 3 i.e.
> Criteria 3 --> Sorting order will be from B --> J.
>
> (a) if you see in your solution file Row 6 & 7 (Name G & A) has count 4,
>
Hi group,
I have a small query in VBA, Pls check my file for details,Pls Help
Thanks In adv.
--
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
Dear Manjunath,
Pl elaborate some more.. didn't understood
Warm Regards,
Gawli Anil
On Fri, Mar 8, 2013 at 7:13 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Anil,
>
>
>
> Can I use same for existing sheet.
>
>
>
> Example : I have an data in 2nd row & followed b
Dear Karthikeyansankaran,
Goto sheet view code their select worksheet from dropwdown.
Write the code .
ActiveCell.Interior.ColorIndex = 36
Warm Regards,
Gawli Anil
On Sun, Mar 10, 2013 at 5:53 PM, karthikeyan sankaran <
karthikeyansankar...@gmail.com> wrote:
> Hi,
>
> How to highlight ActiveC