Search results

Dear sgmpatnaik Please send the file on my email id i will try to get that password vijaykumar@yamaha-motor-india.com

Dear crouchsw When i try to executive the script file, every time my code will error in the line .AdvancedFilter (became highlighted in yellow color) error was illegal field name. But now i have changed the code (Latest code) and it works. There are around 15 files in Testing folder. In every...

Dear jeffreyweir I have removed the msgbox line, and it gives error and highlighted the after else statement i.e. xname.delete. Ok i will try again , revert to you Thanks a lot Regards Vijay

Dear jeffreyweir Have tried after delete the statement MsgBox (xName). If you will delete this line, then it will gives an error message. Please try

Dear asafraz81 Please find below URL: http://www.ozgrid.com/forum/showthread.php?t=72190 change as required Sub IsWorkbookOpen() Dim wbName As String Dim wb As Workbook ' First you pass the sub the filename somehow, inputbox or cell ' or Sub parameter or whatever. Note...

Dear Webmax You can use Excel built in Function EXACT. It will compare text1 and text2

Dear All Please find below code. I want to use this as Task Schedular script. So i saved this as .vbs. When i have first executed it, it works fine & next time it gives error like "The extract range has a missing or illegal field name." in the specified file. If i open that excel file and...

Dear All Please find below code, i found this code in search engine. In this code why confirmation through msg box required to delete the hidden names & if i removed msgbox line then it gives error. Is there any to delete all hidden names without any confirmation required Sub...

Hi All I am trying to write a VBA code which can select emailid based upon filename and then send mails to the concerned person. So i am going to use Select Case Statment, but it can't work. I am unable to solve the problem as i am new to VBA. So please help to resolve my problem. I have tried...

Hi Bhushan Can you post complete code or any sample workbook

Hi Ryan Basically, the second Formual ISNA is used to remove #N/A error values when the lookup value (C$$ value) not found in the range. To make better formatting, we used ISNA formuala along with IF formula which will check error values, if error value found, then the formula will convert the...

Hi Bartus Can you elaborate your problem in more. Actually i can't able to understand what do you want with Conditional Formatting 1. Assume that you have range (A1:A5000) and you want to apply CF that if A1 value greater than 1 then it should format and like so. If that so then select the...

Hi Ryan =IF(ISNA(VLOOKUP($C4,'temrs master data'!$B:$D,COLUMN(B$1),0)),"",VLOOKUP($C4,'temrs master data'!$B:$D,COLUMN(B$1),0)) Step 1 VLOOKUP($C4,'temrs master data'!$B:$D,COLUMN(B$1),0) The above formula will find the $C4 value in temrs master data'!$B:$D (data range) and whenever the C4...

Dear Debraj Roy Thank you so much, it worked, but i need one more step like, if that value already put in some where then i need to put it in color cell. I mean to say A1 = AAA A2 = AAA A3 = AAA by conditional formating,A3 filled with color yellow, and i already put value in A1, my...

Dear All, I want to try a task in excel, but can't able to acheive, so please help me to resolve it By conditional formatting, i am highlighting the entire row with Yellow color, now i want to put a vba code which can put 1 in a cell (any cell in a column) in that highlighted row. I am...

Dear SenthilKumar_rm Why don't you use PIVOT Table for this, Its very simple Insert Pivot Table and put Value in values label and click value field settings and select min instead of sum. Regards

Dear Rahul Sharma If you like Pivot Table then please try this Select A1 and press INSERT--> PIVOT TABLE --> insert pivot table in existing sheet (i selected G1) Employee as Row Lables Overtime as Values Labels Date as Row Labels Select G3 and click Group Field in Pivot Table...

Dear Rahul Now i got your point, please let me work on that meanwhile please see http://chandoo.org/wp/2010/06/24/between-formula-excel/ may it solved your prob Regads

Dear Rahul You can also use Pivot Table to do this, Its very simple and quick solution Please try it by putting the cursor on A1->insert->PivotTable Regards

Can you please share your complete code or file for better understanding

Dear RahulSharma Why don't you use SUMIF function, i use this function in your data, it works fine =SUMIF($B$2:$B$34,F2,$C$2:$C$34) by taking cell F2 for the date as a criteria =SUMIF($B$2:$B$34,B2,$C$2:$C$34) by taking B2 as criteria and drag to down If other than this requirement...

Dear Colin Legg/Narayank/Hui Thank you so much to put your efforts in my problem. Finally Colin Legg solution worked better, and now the custom properties window opens. Once again thanks to all of you. Regards Vijay

Dear Colin Legg Sorry for delay in replying I am using window7 64bit and msoffice 2007 Dear Narayank I already read this, before posting this problem in this forum.

@Narayank991: both learning and part of my vba project. The reason is to access custom properties is, by run time i can add headers but i need to fix it, so i need custom properties and secondly, i joined chandoo's VBA classes, in that one tutorial explained about list view control, he shown me...

Dear All Sorry for delay in replying @NARAYANK991: I can't able to upload the file, becoz the sharing & storing sites are blocked in my office @Hui: I can't able do replaring, becoz it's an office system, admin rights not provided @Colin Legg: I have downloaded that dll, but can't...