Anyone know how I can resolve the error message I am getting.or
have similar code that I could try.
Hello, I am trying to accomplish the following, in case anyone knows
how to do it.
I need to (1) take the contents of the active cell, (2) open my
yahoo
mail in internet
Please explain it little bit extensivly.
It is a good function but proper usage is not clear from ur example.
On Tue, Mar 17, 2009 at 7:43 AM, Alokeshwar Tiwary
alokeshwar.tiw...@yahoo.com wrote:
Just thought of sharing this function with the group. I created it to
elaminate lengthy
Gohar --
Let's say you are evaluating Column A
-- you can use something like the following formula in Column B
=IF(COUNTIF(A:A,A1)1,repeated,not repeated)
... just enter this in B1 and copy it down
Hope it helps you !
- Rodney POWELL
Microsoft MVP - Excel
www.BeyondTechnology.com
Thanks..Harmeet
But i wanted to find out Mukesh in cell B1 itself not how many times it
appeared in column.
sorry if i had not put my question right.
Gohar
On Tue, Mar 17, 2009 at 5:49 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
See attached file.
On Tue, Mar 17, 2009 at 12:34 PM,
Hi All,
Can anyone help me how to break a vba protect password.
Regards
Hari kumar
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA
Hi Ashish,
We are waiting for your email on the details of the
prize.
On Tue, Mar 17, 2009 at 2:09 PM, Ajay Varshney
ajayvarshney21...@gmail.comwrote:
Hi Ashish,
According to your email, we were suppose to get information about our gift.
But as of now, we have not
Hi Ashish,
Thanks Alot. This is great. I am able to open the desired link. However
now I need to copy the value of each cell in a column to the search field of
this site and then click. I know that I can run a loop to copy value from
each cell and then paste it in the search field.
I then
Construction of PIVOT TABLE may solve your problem.. Select Count instead of
values in Data field..
ankur lodha
Date: Tue, 17 Mar 2009 00:04:07 -0700
Subject: $$Excel-Macros$$ Repeated Value in a Column
From: goh@gmail.com
To: excel-macros@googlegroups.com
Dear All
How to
Hi Excelites,
I want to apply a index function to a combo box. But i could not.
Requesting you to help me on this.
Pls. find the attachment.
Regards.,
Johnson Dara
--~--~-~--~~~---~--~~
Hi all!
I have a problem with Data Validation, when i copy and paste where
Data validation is, than the data validation doesnt check anymore! So
how can i check the entries after i copy paste??
thanks
--~--~-~--~~~---~--~~
Solution is in the attached file..
On Sat, Mar 14, 2009 at 12:10 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hello Ajay,
I am attaching here below the excel sheets with some examples for my to do
list on some particular dates.You can find them in sheet 2 and i want the
HI,
Please find the attached file. Hope, this would solve your problem.
On Fri, Feb 27, 2009 at 9:59 PM, Paul Schreiner schreiner_p...@att.netwrote:
That's kind-of difficult.
first of all.. checkboxes are not usually tied to rows.
They're usually kind-of floating around the spreadsheet,
Where is the file.
On Thu, Mar 19, 2009 at 1:20 PM, hari prekkeh...@gmail.com wrote:
Hi All,
Can anyone help me how to break a vba protect password.
Regards
Hari kumar
--
Thanks Regards,
Harmeet Singh
--~--~-~--~~~---~--~~
Hi Members,
I extremely apologize for the delay and is thankful to your patience and
mutual understanding. To a clue, it's an excel utility which can save your
loads of time and is available on various excel addins sites. I'm working on
some extremely new features, never seen before and heard.
Attached workbook has the solution.
On Wed, Mar 18, 2009 at 5:27 PM, johnson dara johnsond...@gmail.com wrote:
Hi Excelites,
I want to apply a index function to a combo box. But i could not.
Requesting you to help me on this.
Pls. find the attachment.
Regards.,
Johnson Dara
--
A little help and I would be done..
Thanks again
On Mar 12, 10:07 pm, kanwal_no1 kanwal...@gmail.com wrote:
Hi Ashish,
A little help and I would be done..
Regards
Kanwaljit
--~--~-~--~~~---~--~~
The following does what you describe:
Public Function FMT(s1 As String, s2 As String, s3 As String, s4 As String)
As String
s1 = Format(s1, #)
s2 = Format(s2, 0#)
s3 = Format(s3, 0#)
s4 = Format(s4, ###)
FMT = s1 . s2 . s3 . s4
End Function
s1,s2,s3 and s4 are the four
Prabhakar,
Here is the structure of the Function:
MyVLookUp(Lookup_Value As String, Lookup_Range As Range, Column_Index As Long,
Optional Left_Lookup As Boolean)
Lookup_Value = same as lookup_value in vlookup
Lookup_Range = same as table_array in vlookup, but here you need to select a
Dear,
Could you please send me the software Able2Extract or the link from where I
can download the full version of the software.
Thanks and regards,
Kamal Gulati
On Tue, Mar 17, 2009 at 1:41 PM, Chinmay Antani
chinmayantan...@gmail.comwrote:
ajay i have a sofwatre called Able2extract which
Hi xmux,
This is the main weakness of data validation. The only way around it is to
check the entry using a VBA Change event code.
Regards - Dave.
_
View photos of singles in your area. Click Here
-
Hi Kanwal,
Please re-explain your problem, if this link to excel file doesn't
solve your problem.
http://groups.google.com/group/excel-macros/attach/a6c9a594e4b3c30f/VBA+form+Auto+Resizing.xls?part=4view=1
For
-
Hi xmux,
Dave is absolutely right. and here is how you can achieve this.
1. Press Alt+F11.
2. Double Click on the Sheet in Left pane, where you've placed Data
Validation.
3. Then Paste the following code in Code
---
Hi S Baloo,
Can you please reply this mail by attaching the worksheet, so that we
can finely understand your problem?
For more tips, tricks,
---
Mr. Hari,
Mr. Hacker Singh is asking for file. lolz.
Carry on helping harmeet. Nice !!
For more tips, tricks, downloads and problem solutions:
Hi Mike,
The code was working absolutely fine on my system and I tried now
again, again it is working fine.
1. I've modified it a bit for you but if you still receive the same
problem then execute it step-by-step using *F8* Key.
2. I'm using Yahoo Classic version, this code doesn't work in new
Hi Mike,
The code was working absolutely fine on my system and I tried now
again, again it is working fine.
1. I've modified it a bit for you but if you still receive the same
problem then execute it step-by-step using *F8* Key.
2. I'm using Yahoo Classic version, this code doesn't work in new
*Also You can Try Offset formula for the same*
On Thu, Mar 19, 2009 at 6:50 AM, Alokeshwar Tiwary
alokeshwar.tiw...@yahoo.com wrote:
Prabhakar,
Here is the structure of the Function:
MyVLookUp(Lookup_Value As String, Lookup_Range As Range, Column_Index As
Long, Optional Left_Lookup As
hi guys
great being on this group
can u unsubscribe me for now
regards
gaurav
On Thu, Mar 19, 2009 at 10:16 AM, Ashish Jain 26may.1...@gmail.com wrote:
---
Mr. Hari,
Mr. Hacker Singh is asking for file. lolz.
Hi,
You can try doing past special values this retain the validations
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of xmux
Sent: 18 March 2009 06:14 pm
To: MS EXCEL AND VBA MACROS
Subject:
Oh my god.
Look, who is back in the gang.
its Ashish.
On Thu, Mar 19, 2009 at 10:16 AM, Ashish Jain 26may.1...@gmail.com wrote:
---
Mr. Hari,
Mr. Hacker Singh is asking for file. lolz.
Carry on helping
Hi Harry,
Its m !!
Yhoo !!
Let's Rock on!!
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified
Hi Harmeet,
Thanks for your solution.
Can you pls. explain where did i go wrong?
thanks regds.,
Johnson Dara | APC by Schneider Electric | Manager (Finance)
Mobile: +9845370350
Email: johnson.d...@apcc.com | Address: 27, Lavelle Road, Bangalore 560
001 INDIA
*** Please consider
See attached screenshot. Will help you.
On Thu, Mar 19, 2009 at 10:37 AM, johnson.d...@apcc.com wrote:
Hi Harmeet,
Thanks for your solution.
Can you pls. explain where did i go wrong?
thanks regds.,
*
Johnson Dara* | *APC* *by Schneider Electric* | *Manager (Finance)* *
Thanks Ashish for suggestion.
Will surely give explanation if I will be having enough time.
Dear users, please reply to the group if anytime you need more
clarification. Anyways I will try to elaborate more in future.
On Thu, Mar 19, 2009 at 10:14 AM, Ashish Jain 26may.1...@gmail.com wrote:
34 matches
Mail list logo