Search results

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,

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

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,

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

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,

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?

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,

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

How could i change value of variable from one line to another, or say it should be calculate every time. File is attached and the concerned variable is lastrow which is not updating its value even when i have mentioned it in the beginning of module. codi is : Option Explicit Dim lastrow As...

Hi All, There is some problem in coding it goes to line 2 after line 3. I dont know why, might be somebody knows this.. Sub test() Dim Last_Row As Double, File_Name As String, sht As Worksheet, Wb As Workbook File_Name = Application.GetOpenFilename(filefilter:="Excel Files (*.xls*), .xls"...

Hi, how should i use average functioin in attached sheet but i dont want it with helping columns. As it contain char(160) in it . please help me on this Regards,

How could I rename all of my sheets with names Jan, Feb, Mar,…..Nov, Dec and one with total. Is possible without using any range reference. I have listened about like method will it give solution for renaming it. Regards,

Hi team, I have created a simple macro which is changing some integers into string from referenced column. Coding for the same is Sub integer_to_name() Dim Int_rng As Range, name_rng As Range, cell As Variant Set Int_rng = ActiveCell.CurrentRegion MsgBox Int_rng.Address Set name_rng =...

Actually i was reading http://forum.chandoo.org/threads/personal-macro-doesnt-open-with-excel.13979/ http://forum.chandoo.org/threads/personal-workbook.5208/ http://chandoo.org/wp/excel-vba/vba-tips/ and now i am aware that what we can do immediate window ?application.StartupPath and want to...

Hi All, I am a learner in VBA, and confused in between static variables and constant varialbes. Also which one is default. If would be great if explained with example. Thanks in advance

Hi Ppls, i am trying to highlight my activecell with skyblue color for the same i used event Private Sub Worksheet_SelectionChange(ByVal Target As Range) and it is working fine as i have instructed it and the i am unable to instruct is to reset its color while leaving cells as it is that is...

Hi All, Please help in making a dialouge box where i could get my desired text instead of open in open dialouge box. please find the attached image where i have tried to explore my words. instead of open there should be like this "open september mid day collection file" Hope it is undestandable.

Hi, Being a new to VBA excel :( I am learning from this forum I read the old threads one by one to become :awesome:. But for navigation in thread i have to re-click on Forum header then need to go to list and then i go for next thread. Is there any another method to Navigation between threads...