*Hi Paul :* If I add this code in my code it creates new sheet and deletes
immediately. Pl look in to this.
*Hi Ashish :* Your file is creating new sheet every time but I want the
same sheet to be overwritten with changes.
Thank you,
On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar
wrote:
> Hi P
Welcome Sharath.
Regards
Ashish
--
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 titles. Poor thread titles, like
Thanks Ashish,
This is exactly what I wanted!
Regards,
Sharath
On Thu, Nov 13, 2014 at 7:26 PM, Ashish Kumar
wrote:
> Hi Sharath,
>
> PFA..!
>
>
> Change your data in A1. If you select Global in A1 then drop down list
> will show in B1 and If you select Local in A1 then drop down list will
I FIGURED IT OUT ! , :) There was " _" missing after "And"
its working now
Thanks
On Thu, Nov 13, 2014 at 10:42 AM, Paul Schreiner
wrote:
> is FileFolderExists() a custom function?
>
> is this email wrapping?
> that is, is this actually one line?
>
> If FileFolderExists("\\cf3.pepsico.pvt\psr
is FileFolderExists() a custom function?
is this email wrapping?
that is, is this actually one line?
If FileFolderExists("\\cf3.pepsico.pvt\psra\Output\BI4\Exec Dollars - Current
Period.pdf")and
weekday(date) = 2 Then
if so, be sure there's a space after the )
If FileFolderExists("\\cf3.pep
Compile Error:
Syntax Error
the above error is coming for the below code . it happens when inject the
Day condition
Private Sub TestFileExistence()
If FileFolderExists("\\cf3.pepsico.pvt\psra\Output\BI4\Exec Dollars -
Current Period.pdf")and
weekday(date) = 2 Then
Range("A1").Value = "X"
Hi Pravin,
PFA.!!
Regards
Ashish
--
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 titles. Poor thread titles,
Hi Sharath,
PFA..!
Change your data in A1. If you select Global in A1 then drop down list will
show in B1 and If you select Local in A1 then drop down list will be
deleted in B1. you are able to write anything in B1
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Nov 13, 2014 at 5:59 PM, Pol Ktk wrote:
> Ultimate Sir
>
> Thank you..
>
> On 13 November 2014 16:38, Vaibhav Joshi wrote:
>
>> here you go... ensure not
why not simply delete the sheet if it exists?
add this to your code before you copy the sheet:
On Error Resume Next
Application.DisplayAlerts = False
Sheets("Party Wise").Delete
Application.DisplayAlerts = True
On Error GoTo 0
'--
P
Hi Ashish,
I am sorry I was not clear in my email.
Let me clarify.
Cell A1 has a drop down list ("Global", "Local")
If someone selects "Global", Cell B1 should show a drop-down list which is
coming through a named range. I have that assigned.
But, if the user selects "Local", the Cell B1 shoul
Hey Kalyan,
check this array formula and the
sheet.
=COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0))
Regards,
Mandeep Baluja
On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
>
> Dear Experts,
>
> Please help me to solve my query.
>
> Thanks in adv
*Hi,I have recorded a macro to create a new sheet called "Party Wise" based
on the info available in sheet called "Pending CN"When I go for second
attempt it's giving an error because of the sheet name.Could you please
look in to this and arrange a solu
Hey Kalyan,
check this formula and the sheet
. =COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0))
Ctrl+shift+Enter
Regards
Mandeep Baluja
On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
>
> Dear Experts,
>
> Please help me to solve my query.
>
> T
Hi,
PFA Solution,
Regards
Sanjai Kumar
On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
>
> Dear Experts,
>
> Please help me to solve my query.
>
> Thanks in advance
>
> --
> *Kalyan Chattopadhyay*
>
>
> *Executive Corporate MIS*
>
> *Joy Cosmetics*
>
--
Are you =EXP(E:
Thanks Broo. Have you got your MVP award :)
On Thursday, November 13, 2014 2:47:19 PM UTC+5:30, Mandeep Baluja wrote:
>
> Please explain the last line !! What's going on in that line what is \b
> ?? etc etc
>
> Set re = CreateObject("vbscript.regexp")
> re.IgnoreCase = True
> re.Global = True
Ultimate Sir
Thank you..
On 13 November 2014 16:38, Vaibhav Joshi wrote:
> here you go... ensure not to change input sheet name or if you chage them
> update code..
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through m
Hi,
I am looking for some help on data validation.
If the value in cell A1 is Global B1 should display a dropdown list. If the
value is Local, B1 should be left editable to the user to enter value of
their choice.
I appreciate your help.
thank you,
Sharath
--
Are you =EXP(E:RT) or =NOT(EXP(
Dear Experts,
Please help me to solve my query.
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
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
This one is for what you are looking for...
http://www.regular-expressions.info/email.html
+
*I did not do this for you. God is here working through me for you.*
On Thu, Nov 13, 2014 at 2:47 PM, Mandeep Baluja
wrote:
> Please explain the last line !! What's going on in that line what is
Hi Mandeep
Check this...https://www.udemy.com/blog/vba-regex/
http://www.macrostash.com/2011/10/08/simple-regular-expression-tutorial-for-excel-vba/
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Nov 13, 2014 at 2:47 PM, Mandeep Baluja
wrote:
> Pl
Macro goes here...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Nov 13, 2014 at 1:05 PM, Amit Desai (MERU)
wrote:
> Dear Ashish,
>
>
>
> Thanks a lot for your efforts. However, I need the output in the same way
> as in my file...only difference i
Hi Amit Sir,
PFA. Don't delete the formula which was in C column and F Column.
Enter your Data in E Column and drag the formula.
Regards
Ashish
--
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 Eugene,
For fix the shape in one position.
Left Click on the shape
Click on Format Shape
Click on Properties
Click on "Dont Move or Size with Cell"
OK
Regards
Ashish
On 13 November 2014 16:38, Eugene Bernard wrote:
> Hi all,
>
> FInd attached an excel sheet, where in i pasted a circular s
here you go... ensure not to change input sheet name or if you chage them
update code..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Nov 13, 2014 at 12:05 PM, Vaibhav Joshi wrote:
> With macro also it is possible & quite easy.. will send you soon.
Hi all,
FInd attached an excel sheet, where in i pasted a circular shape in that
sheet.
Whenever i scroll down the row, or move accross the column, I want keep the
circle on the same position. ie i want to see the same always still i close
the sheet.
Regards
Eugene
--
Are you =EXP(E:RT) or =N
Cheers Mandeep !!
On Nov 13, 2014 2:29 PM, "Mandeep Baluja" wrote:
> Hello All,
>
> My name is Mandeep , I have been working as a MIS Executive since 1 year.
> I have keen interest in excel and love the power of VBA. Hope I will help
> you in some of your issues.
>
> Regards,
> Mandeep Baluja
>
>
Please explain the last line !! What's going on in that line what is \b ??
etc etc
Set re = CreateObject("vbscript.regexp")
re.IgnoreCase = True
re.Global = True
re.Pattern = "\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,6}\b"
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An
Hello All,
My name is Mandeep , I have been working as a MIS Executive since 1 year. I
have keen interest in excel and love the power of VBA. Hope I will help you
in some of your issues.
Regards,
Mandeep Baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=
Hi Amit Sir,
PFA. Don't delete the formula which was in C column and F Column.
Enter your Data in E Column and drag the formula.
Regards
Ashish
--
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
30 matches
Mail list logo