creation

I'm having trouble with my chart creation macro and would greatly appreciate any help. I want it to import data from the sourcesheet and create a chart for each row (macro is working for it); however, I'm trying to make my macro to edit the charts and not include a specific year if it has...

Hello, I'm very new to this forum, just created an account because I've been googling for hours and I can't find a solution to my problem. Hope someone here will be able to help me. I have a 1st table, called "IDStatusSettings" in Sheet 1: This table is displaying datas from other sheets in...

Hi, i am curikus whether it is possible to set a macro for afterupdate action for created in runtime combobox? I get an error for not supporting such operation: ...'creation of cb on button click MyCB.afterupdate = "mymacro"

Hi, So I have a monthly report that I have automated to refresh with new data and perform other preparations. One tool I have will cause the header to change color if filtered. That way I don't forget the filter and allow it to mess up the rest of my work. I want to add the creation of this...

Howdy, I have used this code before for other sheets in my workbook. I changed the name to be the new worksheet and adjusted the code throughout my workbook to include the new worksheet. I get the Compile Error: Variable Not Defined when ever I point to the Set wsIBMass (new worksheet). I am...

I have a spreadsheet "Student Data Directory 2013-14.xlsx" where column C is LastName and column D is FirstName. I have folder /Volumes/SHARED/FANNON_JOBS/34899_EHS Directory 2013/Originals/Directory Second Submission/Photo where the files are named "lastname firstname.jpg". What is the formula...