Search results

Please help me in same, I am new to vba, know loop only for.....each.... how could I do this with for.....each....

How Could I change file format (extension) in folder and sub folder in single go. is there any way to change .xlsx to xlsb. it would be great help. Regards,

What do you mean by IMHO ?? Yes you are right that after restarting system it does not shows same.

I am working with some files which are kept on server and sometimes it shows that file is already open by gauravkr how ever gauravkr has not opened the file. what could be the possible reasons for the same. Regards,

Hi All, In attached image I got visualizations challenges and as per my brain (if it is) it could be done by using blocks of webding1,webding2,webding3,webding4 fonts or similar family. pelase help me out

Hui Sir, Thanks for reverting my concern but sir I we also use it in same way for countifs/vlookup it works there fine. so just for curiosity why it is not working here

Hi All, Today I came up with a new problem I usually use wildcards for advance filter/find/replace/countif/vlookup but today I used it directly to check whether cell contains "DON*" or not but it didn't work. VALUE IN cell: DONE IN another cell: =cell="DON*" Image is attached Regards,

@Tiago MF - WOW .. a cool trick I was not aware of same thanks dude @Hui - Thanks a lot I used your solution around in 25 files of mine. Regards

Is it possible to create a graph with target line but without secondary axis. because graph figures are controlled by drop down and axis option for min/max & min unit/max unit are not same. file is attached for referenc Regards,

Hi All, I am came up with a new problem I have excel 2010 but now days I am unable to drag and resize print area in page break view. please help me out. and it is happeining in all files of my system

Hi all, please help me to get out of this thing, blue table is calculated file. all of the stuff is explained in attached image in understandable manner. thanks

@Wudixin I missed below line Just open another workbook via the opened workbook thanks a tonne brother you help me a lot

Wowww, Its awesome its awesome thank a ton bros

Hi All, working with advance data filter, can you please suggest what should i do to get for criteria "Empty"& "Non Empty" cells together. currently * is working with "Non Empty" cells hope it is cleat please help. Regards,

Thanks Khalid/Narayan sir for your help, @Khalid i am using 2010 so keeping it 90 degree is not making it vertical altitude @Narayan sir, gr8 findings sir i am very happy with this new learning thanks alot you both

thanks for your tip wudixin but I have 2010 what should I do. it consume my lots of time for copying a data from another workbook to this workbook and then applying vlookup or other functions as well

Hi All, I am unable to create shape line accurate @ 90 degree vertical is there any trick to do same.

Hi All, I came up with a new chaleenge (at least for me) i.e. vlookup not working. actually whenever i write syntax =vlookup(lookupvalue,table array=anotherworkbook,.......) then another workbook array/range does not get selected. file structure are as below : may or may not be shared may or...

Hi All, is there any specific reason why I don't get auto populated list in excel vba while coding everytime. it comes but only sometime. below is the snapshot of the drop down list I am not getting Regards

Is it possible to highlight latest excel file in a folder, suppose I have a folder "NORTH TEAM" which I need to update every day but my boss want to keep highlight latest file ? I have said them no as of now as per my knowledge please correct me if there is any possibility?

Thanks Luke, You are right its same you told its shared.

Hi All, Just to know how could i go to Coding page where i am getting prompt after Alt+F11 snap is attached. Project is unviewable. Regards,

Hi All, Today while troubleshooting with a corrupted macro, I faced subjected two new variable (for me :( ). I know that they are linked some where with SQL so can you please explain me this. It would be better with example if possible & does its uses also need to add/check some library. Regards,

Thanks guys for looking in it. @Khalid i want to get rid of cell reference and text function as you see in cell E7 input is only date and for viewer it is different than date. i.e E7 = 1/1/2015 for viewer it is Gaurav kr gautam has created this file on 1-Jan-2014 so is it possible to calculate...

Hi All, I am trying to update cell format i.e. Gaurav kr gautam has created this file on 1-Jan-2014 to 6-Jan-2014 with only entering the dates. I am done with first part but want second part Regards, Tarun Verma