Search results

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...

Y it is happening coz i am a vba newbie and see each & every steps/action pls suggest what should i do to proceed in my learning towards ninja. ;);) Regards,

I am using F8 keys to see step by step action and after opening file it again goes on line2 to : File_Name = Application.GetOpenFilename(filefilter:="Excel Files (*.xls*), .xls", Title:="Open Weekly Report - Step 1 of 8") Regards,

Thanks Narayan, Narayan actually i am working for automation of my report which includes: 1-open 1st file 2-copy some range 3-open 2nd file 4-paste values of 1st value in 2nd file 3.close 1st file Honestly i want to become a ninja but still a newbie in vba from past 1 year. Small things are...

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"...

Thanks Luke you are genius but I answerless to my self o_O, why it was not working with my coding:rolleyes: Set Range_by_GauravKrGautam = ActiveCell.CurrentRegion.Columns(ActiveCell.Column - ActiveCell.CurrentRegion.Column + 1) Set Range_by_Chandoo_Ninja = Intersect(ActiveCell.EntireColumn...

No problem, i should also take care of that little thing. However i would like to tell you that you have make my work too much easy & quicker. i will save around 1 hr of a day with this. Regards, Gaurav

Thanks Mike for helping me out of this I was wondering that why it was not working on my system but after few amendments it is working I changed coding from Sheets(x).Name = Format(DateValue("1/" & x & "/2014"), "mmm") by below one Sheets(x).Name = Format(DateValue(x & "/1" & "/2014")...

Thanks mike 4 your kind revert i tried to use code but not working where should i change PFA

thanks for your effort bt answer are not matching PFA

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,

Hi Smallman, Can you please explaint your steps of this coding. it would be a good learning for me. Regards, Gaurav Kr Gautam

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...

Thanks Hui for kind revert i tried it out and able to get the name at title and also selected multi file but they are not opening. i am getting msg box with full path of file bu files are not opening.

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.

Yeah :DD, Nice trick Narayank991 Its same as i want its so simple... Hmmmm... & I can keep indexing myself on which post i am reading. Many Thanks Narayank991

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...

Is above problem is too much easy or too much difficult that is not anwered, pls help me

Hi All, Good Morning All My Seniors (IST) I am working on two macro based file where one is team performance (Source File) and other is Day-On-Day Database (Destination File). Destination file contains table with few columns with some formula (Column F). Now challenge is that source file has...

Hi Ppl, I am trying to update my pivot table with macro on the basis of a cell reference. Pivot filter should select only one date i.e F6 and unselect all other values i.e. F5 & blanks. and also like to know why the pivot filter drop down format in unchangeable as in sample file it is in...

Many Thanks Deb i tried it & its been working fine i was using reference of named range with chart names instead of linkeed cell, thanks for sharing path of same things. Choose(....., graph name1, graphname2 ) were chossing from linked cell 1or 2 or 3 respectively got the conecept and will...