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.
0 kommentar(er)
