Dear Premor,
I could able to learn something about VBA-Macros after joining this group
only.. and before that even I didn't think that it that excel could do such
a nice work for users. As I do not know in deep about VBA, I would request
you to please do me a favor in this regard.
Thank you,
Re
Why didn't you write your own code, i was send enoughsample code for
create that, i think this is the time for you to find your own fish.
Rgds,
[dp]
Pada 11/07/2013 12:08, Pravin Gunjal menulis:
Dear Premor,
Before save code is working fine and creating a backup, if you arrange
the same code
Dear Ashish/Basole,
Thanks for quick response; I really appreciate your efforts,
I think how to copy web page to excel ( I tried via “Get External data from
web” excel
option but unable to fetch ActiveX control)
Basically I want go to web page then select all value (using ctrl +a) then
pa
=TRIM(RIGHT(D3,LEN(D3)-FIND(")",D3)))
Regards
Ashish Koul
On Wed, Jul 10, 2013 at 4:20 PM, Prafull Jadhav wrote:
> Dear Amar,
>
> find the same with easy...by using mid function.
> Regards
> Prafull
>
>
> On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar wrote:
>
>>
>>
try this
Sub Loopobjects()
Dim OleObj As OLEObject
Dim sel_d, val_s
Dim Arr
Dim ArrMatch
Dim lngSelected As Long
For Each OleObj In Sheet1.OLEObjects
If OleObj.progID = "Forms.HTML:Text.1" Then
Sheets(1).Cells(OleObj.TopLeftCell.Row, 12) =
OleObj.Object.
See if that is what needs:
http://www.homeandlearn.co.uk/excel2007/excel2007s8p4.html
Em quarta-feira, 10 de julho de 2013 09h51min06s UTC-3, Santy escreveu:
>
> Hi,
>
> I need help urgently
>
> how to copy value from an object (i have copy objects from web page)
>
>
>
>
> Thanks in advance
>
Hi,
I need help urgently
how to copy value from an object (i have copy objects from web page)
Thanks in advance
--
Regards,
Santy
--
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
Probably its too latestillI was searching for some code related to
Crystal Report and found your post. :)
This code might help ( you need to set reference to Crystal Reports ActiveX
designer Design and Runtime Library 11.0 or above)
Sub CrystalRPTtoXLS()
On Error GoTo ERRMSG
Dim Appl
Dear Murli,
You can just give ref of column,,, for example if you want B column then
put (B:B).
=VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0)
On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E wrote:
> Hi,
> Dear friends,
>
> Thank u
>
> With the same i want to know using column & columns
>
> *2.Thi
Hi,
Dear friends,
Thank u
With the same i want to know using column & columns
*2.This is using columns or column function*
=vlookup(lookup_value, Table array,*columns or column(array)*,range lookup).
I want to know how can we use both these functions.
1. Shall we can get the left side result
Hi,
The empty value is because you have not given any criteria when the match
is not found.
For Example : Use this : =IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),"Not Found",C1)
Currently none of the values which you have in Column "C" are present in
Column "E"
Regards,
Sandeep
On Wednesday, 10 Ju
Dear Murli,
Find the same
Regards,
Prafull Jadhav.
On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E wrote:
> Dear friends,
>
> Good afternoon,
>
> I need a help and I want to know how to use vlookup function by using
> match and columns function. How it is works?
> Plz, share with me.
>
> *1.This
Dear Amar,
find the same with easy...by using mid function.
Regards
Prafull
On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar wrote:
>
> --
> *From:* amar takale
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, 4 September 2012 2:01 PM
> *Subject:* $$Excel-Macr
Dear friends,
Good afternoon,
I need a help and I want to know how to use vlookup function by using match
and columns function. How it is works?
Plz, share with me.
*1.This is using match function*
=vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match
type),*range lookup).
*2
From: amar takale
To: excel-macros@googlegroups.com
Sent: Tuesday, 4 September 2012 2:01 PM
Subject: $$Excel-Macros$$ Simple formula required
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ memb
Dear friends,
Good afternoon,
I need a help and I want to know how to use vlookup function by using match
and columns function. How it is works?
Plz, share with me.
*1.This is using match function*
=vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match
type),*range lookup).
*2
16 matches
Mail list logo