Hi Don Sam
Don. appreciate your comment. I had not made it clear what I was looking
for. Apologies.
Sam, yes it is working great with dbl click or right click. It does not
work with a single click, which is what I prefer. In use the cell would be
selected and then may also need to click
I don't necessarily support this alternative, and I don't think it is
popular among the old schools either, but it is effective nonetheless. There
is a certain Hyperlink event which could be modified to bamboozle Excel and
make it work to your advantage. The trick is to create a hyperlink to the
hi can u show me how to import the info to the different cells in each
field?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
Hi All,
How to extract number form the cell .
For example
abc123abc
wc34agh
783abcd
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
You are welcome.
Regards,
DILIPandey
On 16 Oct 2011 14:16, Anil Bhange anil.bha...@tatacommunications.com
wrote:
Amazing... I know this group can help me... it save my lot of time...
Thanks Dilip Ashish
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
-Original
Array formula solution
=1*MID(J3,MATCH(TRUE,ISNUMBER(1*MID(J3,ROW($1:$9),1)),0),COUNT(1*MID(J3,ROW($1:$9),1)))
Macro
Sub ExtractNumbers()
Dim r As Range
Dim s As String
Dim v As Variant
Set r = Range(j3, Range(j3).End(xlDown))
s = Join(Application.Transpose(r))
With
Nice work Don..!!
Regards,
DILIPandey
On 10/16/11, dguillett1 dguille...@gmail.com wrote:
Array formula solution
=1*MID(J3,MATCH(TRUE,ISNUMBER(1*MID(J3,ROW($1:$9),1)),0),COUNT(1*MID(J3,ROW($1:$9),1)))
Macro
Sub ExtractNumbers()
Dim r As Range
Dim s As String
Dim v As Variant
Set
Dear Neil,
Please try it to find integer..
Function only_integer(rng As Range)
Dim i As Integer
For i = 1 To Len(rng)
If VBA.IsNumeric(Mid(rng, i, 1)) = True Then
only_integer = only_integer Val(Mid(rng, i, 1))
End If
Next
End Function
--
Thanks regards,
Noorain Ansari
In keeping with Noorain's VBA function, use this formula as an array. This
extracts all numbers irrespective of whether the numbers are together, or
scattered across the text like ABC123DEF, or A1B2CD3EF
Excellent formula Sam... Awesome
Regards,
DILIPandey
On 10/16/11, Sam Mathai Chacko samde...@gmail.com wrote:
In keeping with Noorain's VBA function, use this formula as an array. This
extracts all numbers irrespective of whether the numbers are together, or
scattered across the text like
I have a sheet where I am listing the data (numbers) in columns. I add
data at the bottom of the columns as I get it. I plot a single column
of data using the offset function within a Named range to set the data
to plot against the number of data points input; plus a few blank rows
(e.g. 30)
Send your file with a complete explanation and before/after examples to
dguillett1@gmail.com
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Ken
Sent: Sunday, October 16, 2011 2:29 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Plotting
can anybody help me with auto complete feature incorporation in drop
down list or in a combo box.thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
*Experience:* 3 - 6 Years
*Location:* Noida
*Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG
- Any PG Course - Any Specialization,Post Graduation Not Required
*Industry Type:* IT-Software/ Software Services
*Role:* System Admin
*Functional Area:* IT-Other
*Posted
14 matches
Mail list logo