In Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365 Ribbon, it is hard to find out the Visual Basic Editor command.

Continue to click the View Code item, and then you will view the Visual Basic Editor Window pops up.įigure 1: Open Visual Basic Editor from Classic MenuĬlick the View Code item, and then you will view the Visual Basic Editor Window pops up.įind out Visual Basic Editor in Ribbon if you do not have Classic Menu for Office.Click the Tools drop down menu under Menus tab.If you have installed Classic Menu for Office on our computer, you can find out the Visual Basic Editor in a familiar user interface of Microsoft Excel 2003/XP(2002)/2000:

Seek for Visual Basic Editor quickly if you have Classic Menu for Office

Classic Menu for Office Home and Business.

Classic Menu for Office 2007 Applications.

Reason, references using the sheets command fail.Īnyway, thanks again and hoping there's some easy resolution to this problem. I even tried to run the macro after it's was just recorded, and it won't run, for the same I've even tried using the macro recorder to enter data in various cells in the workbook, but when I cut ann paste the recorded macro into my code it won't work. I've tried activating and selecting various sheets before doing any operations on them and nothing seems to work. Then If Sheets(strSheetName).Cells(iRow, 3).Value = iHour Then IMonthStart = Sheets('PlotWeatherStation').Cells(2, 4 + (3 * iPeriod)).Value There are about 30 different sheets with raw data on them, solar data, and I'm just summarizing and graphingĪnyway, the referencing that I once used no longer works and I'm not sure why. I only installed 2013 to see if my macrosĪfter looking thru things in a little more detail today I'm finding that my basic problem is with references to the various sheets in my workbook. I've since deleted Office 2013 since it was interfering with my newer Office 2016 installation, but while I had it installed I had the same problems with my macros.

Install vba for office 2016