Hello Vaibhv,
It seems formula is wrong count should be 4 but its giving as 7. Could you
please check it.
Thanks in advance.
Regards,
Chandru
On Thu, Sep 11, 2014 at 8:34 PM, Vaibhav Joshi wrote:
> chk this...
>
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through
Hello expert,
I need macro for validate email id.
following is email id format
anyword.deptn...@dome.ac.in
I have above mails ids format, what validations i need is that
if "dome.ac.in" is domain of mail id then
check there is "deptname" present or not in mail id(after
"anyword.")
Hi Paul,
Got it! Idea taken from the Code sent by Bill.
Here's my code and it works perfectly fine for my need.
Sub AgingofReceivables()
Application.ScreenUpdating = False
ActiveSheet.range("A2").Select
Do While ActiveCell.value <> "" 'checking if the cell is not blank
Thank you Bill for the code. Will try it.
Thank you, Paul for your advice. Appreciate it.
Regards,
DanJ
On Wednesday, September 10, 2014 2:35:59 PM UTC+8, DanJ wrote:
>
> Dear Everyone,
>
> I want to categorize age of receivables based on the number of days due
> using the formula below. The fo
chk this...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Sep 11, 2014 at 8:23 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
>
> Could you please let me know what is the issue with sumproduct formula
> where result should be 3
Hello,
Could you please let me know what is the issue with sumproduct formula
where result should be 3 but its giving as 7.
Thanks in advance.
Regards,
Chandru
--
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 th
Thanks for Acknowledgement..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Sep 11, 2014 at 6:19 PM, 'Sleek' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> Thank you,
> I appreciate your help.
>
>
>
> On Sunday, September 7, 20
No problem, once you've asked and answered a couple hundred questions you'll
get an idea of what part of what is in your head needs to be shared to get the
answer you're looking for!
It looks like Mr. Bill has provided a Change_Event macro that could work for
what you want to do.
In case you
Thank you,
I appreciate your help.
On Sunday, September 7, 2014 11:45:57 AM UTC+3, Sleek wrote:
>
> i need to place A,B,C,D, E or F in column D to to be picked from table at
> right.
> A macro or formula could help.
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It
I don't think that's what he's looking for.
the .SaveAS is a workBOOK method, not a workSHEET method.
So, running this macro will save ALL sheets to the new workbook, using the
sheet name as the new filename.
(it works because the "default" workbook for the Activesheet property is the
Activ
Dear Rupesh,
Write below code in a module.
Dim b As String
ActiveSheet.Name = b
Activesheet.SaveAs Filename:="C:\HarshadMacro\" & b & ".xlsx"
Workbooks(b & ".xlsx").Close
On Thu, Sep 11, 2014 at 12:05 PM, Rupesh Patil
wrote:
> Hello Expert,
>
> I need your help.
> I need VBA Macro.
> How to s
11 matches
Mail list logo
