in this attachment did you enabled this library in refrences go to vba
editior enalble these library and then go to sheet1 and click the button
send mails .
microsoft outlook 14.0 object library
ole auotmation
microsoft excel 14.0 object library
visual basic for applications
microsoft forms 2.
Hello,
Can anyone help me to modify & save DBF files in Excel 2007.
Pravin.
On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I tried working on it but could not do the same.
>
> Could you please explain me how to do it or is there any other solution
> for th
Hi,
I have an excel format 2007 for daily data entry, as attached.
I used to select Party Names through drop down list in column F and need to
type the invoice numbers in cloumn E based on the letter in column D.
Our invoice numbers start with C, D & F letters and it comes serially for
differ
remove option explicity statement which is in first line of your code, as
this code working perfecctly on my pc , Please send me the line number of
error.
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exa
Dear Mike,
Thank u so much for your Appreciation. It's a pleasure to help anyone
because it expands my knowledge about VBA , The thing is I am a beginner
and wish i will reach at a position where can i help everyone in anyway it
can be and want to reach at a higher Package in a firm.
wish you
Hi Mandeep,
Thank you, thank you again for your excellent help. Is there anything I can do
for you to show my appreciation? I was really stuck and you bailed me out, I
tried severl different ways and could not get it to work. Thank you, Again.
The Best,
Mike Barrett
From: excel
PFA !!!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exam D
Hi,
Hope you are doing great...
Please let me know your interest along with your updated resume
(If you are not available please refer this Position)
[Please send resumes to r...@technotalent.com]
*Position*
*Role : **Qlikview Developer*
*Location : Jersey City, NJ*
*Duratio
Hi
Check col D for solution..
Cheers!!
On Sun, Mar 15, 2015 at 10:23 AM, rameshwari shyam <
rameshwarish...@gmail.com> wrote:
> Dear Team,
>
> Can any one help on this.
>
> Thanks,
> Rameshwari
> -- Forwarded message --
> From: rameshwari shyam
> Date: Fri, Mar 13, 2015 at 10:0
Dear Mandeep Sir,
Query is still pending from last 2 months. Last time you said that,
you will send the answer shortly.
Revert awaited from your side.
Please help.
Regards
Ashu kenith.
On 1/15/15, Ashu k wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
P
Dear Mandeep Sir,
I am big fan of yours..!
Regards
Ashu Kenith
--
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 concise, accurate thread ti
Cheers!!
On Mon, Mar 16, 2015 at 4:53 PM, Vijayendra Rao
wrote:
> Dear Vaibhav,
>
> Thank you very much for your quick support. This is very helpful.
>
> Regards,
> Vijayendra
>
> 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
>
>> PFA with #N/A handler...
>>
>> On Fri, Mar 13, 2015 at 1:08 PM, Vija
Hey Will Sob it's my pleasure, Vabz I want too add you into my network as i
have started learning Excel techniques and admire your logics of Macros.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Mon
Hi Mandeep,
Logic used in macro is rilli cool...
Cheers!!
On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja
wrote:
> Check the *result sheet* in the attachment . for single single row this
> formula will work with helper column.
>
>
>
>
>
>
> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will So
Hey Will
Check this attachment..in any of given columns it will check occurrence of
10 , 13 & 17 in any order...
Hope you like it,.,.
Cheers!!
On Mon, Mar 16, 2015 at 5:34 PM, Will Sob wrote:
> Gosh l like this method thanks a lot. This is the best l have seen most
> appreciated
>
> On Mon,
Gosh l like this method thanks a lot. This is the best l have seen most
appreciated
On Mon, Mar 16, 2015 at 8:16 AM, Mandeep baluja
wrote:
> Check the *result sheet* in the attachment . for single single row this
> formula will work with helper column.
>
>
>
>
>
>
> On Saturday, 14 March 2015 15
Thank You.
On Sunday, 15 March 2015 22:35:47 UTC-4, Martin Wheeler wrote:
>
> Nothing easily explained. I have done it years ago but would not remember
> how to. Any I have no experience with RSS, just xml Hopefully someone
> with experience will help. Try googling this "how to download rs
Dear Vaibhav,
Thank you very much for your quick support. This is very helpful.
Regards,
Vijayendra
2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
> PFA with #N/A handler...
>
> On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
> wrote:
>
>> Dear Experts,
>>
>> Can you please help me to put vlookup
Run this code in your data
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr = ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Row
Set Rng = Range("C1:C" & lr)
Debug.Print Rng.Address
For Each Cell In Rng
If Left(Cell.Value, 5) = "Estab" Then
esta
Check the *result sheet* in the attachment . for single single row this
formula will work with helper column.
On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote:
>
> Hi,
> Please I need help with the attached file. I want a formula that
> calculates how many times (10, 13, 17) com
Yes it is by macros l like your code but it just won't work
On 16 Mar 2015 07:27, "Will Sob" wrote:
> Thanks for responding yes in a single row. H l would like to know
> about both methods of you can most appreciated
> Tell me two things
>
> is the triplet combination your searching in single
Thanks for responding yes in a single row. H l would like to know about
both methods of you can most appreciated
Tell me two things
is the triplet combination your searching in single , single row one by one
it can be achievedd with concatenate
but if you are trying to search the combination
Tell me two things
is the triplet combination your searching in single , single row one by one
it can be achievedd with concatenate
but if you are trying to search the combination triplet like the I5
contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ??
On Monday, 16
23 matches
Mail list logo