Thanks a lot Rajan Ji for your help. This code is working fine.
Regards,
Mukesh Kumar
On Fri, Sep 27, 2013 at 12:03 PM, rajan verma wrote:
>
> So problem was the reference in formulas , if any formula have reference
> like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here)
Hi Jeremy,
Please find attached file.. The range here I declared is something
different because I think San Diego ($85,394.40) is having amount greater
than 80,000 and less than 90,000 so its percentage should be 5.0% not 4.7%
(as said by you).
Please let me know the limits so that the formula ca
So problem was the reference in formulas , if any formula have reference
like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here)
it will always assume that reference is from activesheet until we provide
full reference like Sheet1!A1:A5, but it is complex to write that code , so
Dear All experts,
Any update on my query Please.
With warm regards,
Rajan Sharma
On Fri, Sep 27, 2013 at 10:33 AM, Rajan sharma wrote:
> Thanks Amir sir,
>
>I have elaborated my query further in excel file, please find the
> attachment.
>
>
> With warm regards,
> Rajan Sharma
>
>
>
>
Thanks Amir sir,
I have elaborated my query further in excel file, please find the
attachment.
With warm regards,
Rajan Sharma
On Fri, Sep 27, 2013 at 10:22 AM, Aamir Shahzad wrote:
> can you further brief?
>
>
> On Fri, Sep 27, 2013 at 9:49 AM, Rajan sharma
> wrote:
>
>> Any body please
can you further brief?
On Fri, Sep 27, 2013 at 9:49 AM, Rajan sharma wrote:
> Any body please suggest formulas or macros. please if it is possible..
>
> Thanks
>
>
>
>
> With warm regards,
> Rajan Sharma
>
>
>
> On Fri, Sep 27, 2013 at 9:07 AM, Rajan sharma
> wrote:
>
>> Dear experts,
>>
>> I w
Any body please suggest formulas or macros. please if it is possible..
Thanks
With warm regards,
Rajan Sharma
On Fri, Sep 27, 2013 at 9:07 AM, Rajan sharma wrote:
> Dear experts,
>
> I want to extract only first and last values or string from Columns,
> Please guide. Please find the attach
Dear experts,
I want to extract only first and last values or string from Columns, Please
guide. Please find the attachment, i have provide sample.
With warm regards,
Rajan Sharma
--
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
Hi everybody.
I am dealing with a rather complex equation, and could use some help. Most
of the cells in the attached spreadsheet are blank, because the data are
confidential. The relevant columns are highlighted.
Basically, I am trying to use index match to find geographic salary
differen
use this one.
Sub PasteFormula()
Dim rngRange As Range
Dim VarArr
Dim strFormula As String
Dim varEle
Dim lngR As Long
Dim lngC As Long
Dim lngCount As Long
Dim wksSheet As Worksheet
strFormula = InputBox("Enter formula name to replace with values")
lngCou
Try this one
Sub PasteFormula()
Dim rngRange As Range
Dim VarArr
Dim strFormula As String
Dim varEle
Dim lngR As Long
Dim lngC As Long
Dim lngCount As Long
Dim wksSheet As Worksheet
strFormula = InputBox("Enter formula name to replace with values")
lngCoun
Rajan ji , this macro code is limited to one sheet only. I want the macro
that works upon all sheets at once.
Regards,
Mukesh Kumar
On Thu, Sep 26, 2013 at 3:39 PM, rajan verma wrote:
> HI Mukesh
>
> i have seen this query many time on this group and another forums, please
> try this macro
>
>
Thanks a lot Sir for the help.
On Thu, Sep 26, 2013 at 3:39 PM, rajan verma wrote:
> HI Mukesh
>
> i have seen this query many time on this group and another forums, please
> try this macro
>
>
> Sub PasteFormula()
>
> Dim rngRange As Range
> Dim VarArr
> Dim strFormula As String
>
HI Mukesh
i have seen this query many time on this group and another forums, please
try this macro
Sub PasteFormula()
Dim rngRange As Range
Dim VarArr
Dim strFormula As String
Dim varEle
Dim lngR As Long
Dim lngC As Long
Dim lngCount As Long
Set rngRange = Activ
Hi experts,
I need a macro code to paste special a particular formula across many
sheets. Every sheet contains different types of formulas, but i have to
paste special a particular /specific formula.
Please help me out.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hello,
Thank you gor the solution for this problem.
Regards,
Chandra
On Wed, Sep 25, 2013 at 9:16 PM, rajan verma wrote:
> Visit here
>
>
> http://excelpoweruser.wordpress.com/2011/08/09/get-unique-list-another-method/
>
> For more method to get unique see this
>
> http://excelpoweruser.wordpr
I already found the solution, i shouldnt use the cid method, but i had to
> put the entire path of the image
>
Thank you so much anyway :)
--
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:/
Hi Anil,
May I know where can I find logs for excel errors?
Thanks
On Thursday, 26 September 2013 11:25:29 UTC+5:30, अनिल नारायण गवली wrote:
>
> Dear Junaid,
>
> Kindly attach the error file .
>
> Warm Regards,
> Gawli Anil
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
>
Hi Rajan,
I get this error, whenever I run the Macro. And below are the two
connection strings I tried, but getting same error for both.
strConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=True;Initial Catalog={abcd};Data Source={abcd};Use Procedure for
Pr
Ok, I’ll try.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Trabelsi Hichem
Sent: Thursday, September 26, 2013 12:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sen
Hello Again,
Thank you Ravi for your quick answer , but the instruction here " .Body =
Ebody " will show in the body the string " Testing VBA's ability to send
an email.", i want the attached image to be displayed normally in the body
that's the problem, it worked before on Office 2003 but no
K try this one.
Sub Sendmail1()
ESubject = "This is a test email"
SendTo = "raviku...@gmail.com"
CCTo = ""
Ebody = "Testing VBA's ability to send an email."
NewFileName = "C:\Users\Admin\Desktop\t\test.jpg" 'change according to your
image
Application.DisplayAlerts = False
Set Ap
Hello,
I Use the following code to send emails automatically with embedded image
in the HTML body, this worked with Office 2003, but when i upgrated to
Office 2010 it doesnt work anymore, the image doesnt appear correctly :
this is the code i'm using :
.
.
.
FileName = "C:\Submission Reminder.
Dear Friends,
Sorry for distrubing you . The solution has been resloved now.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Sep 26, 2013 at 12:29 PM, अनिल नारायण गवली
wrote:
> Dear Friends,
>
>
> I had made a macro, t
Write macro in addin file.
On 26 Sep 2013 12:29, "अनिल नारायण गवली" wrote:
> Dear Friends,
>
>
> I had made a macro, then created a new customized ribbon and assigned
> it with this macro. Problem is whenever i click on the ribbon to run
> the task then the original file where the macro is create
Dear Friends,
I had made a macro, then created a new customized ribbon and assigned
it with this macro. Problem is whenever i click on the ribbon to run
the task then the original file where the macro is created is opening
simulteneously. My idea is it should not open the file and only run
the ma
26 matches
Mail list logo
