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 July
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
Hi,
Paste the code in a module and try to execute again. I will attach the working
excel if possible. Thanks
--
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
Hi,
You can use below code also. I think you want to save a blank sheet with
the required name.
1. Code to save one sheet with the data given in cells 2.
Dim strPath As String
strPath = ActiveWorkbook.Path \
ActiveSheet.Copy
ActiveWorkbook.SaveAs Filename:=strPath Cells(2, 1) - Cells(2,
Hi Everyone,
I am Sandeep S Singh from India Hyderabad. I am a Software Engineer
working with Cognizant. I have just now joined this group It is my first
post.
I work on QTP and Excel Macros. looking forward to interact with everyone
here. have a good day :-)
Thank,
Sandeep Singh
On