$$Excel-Macros$$ Formula Array to VBA Code

I have a search formula that resides in a cell. The idea is if something is found return a 1 if not return 0 based on conditional formatting, a color is assigned. This array seeking the max value for a true instance. Additional piece of info, the search is used a column value, many contain 25 st

$$Excel-Macros$$ Comparing a Named Range to the Current Last Cell

Hi everyone, I am struggling with comparing a Named range to the Last cell in the sheet. I need the named range to be checked and reset if need to the Last Cell. The Logic and code are below. If the Named range = Current Last Cell Then Nothing Else Named range = Current Last Cell. End if

$$Excel-Macros$$ Error 91 - Run Time

I am trying to create a table in Access 2003 through VBA. I keep getting an error 91 where the Object variable or With Block is not set. If appears like I have all the right code to create this table but I can't get beyond the Set statement. Thanks in advance. Dim dbs As Database Dim tdf As Ta

$$Excel-Macros$$ Chart Issues

Thank you in advance because I have been stuck for 2 hours on this issue. The process formats data into a Pivot table because of X/Y needs to be read / formatted. Everything for the most part works correctly except when I want to format the actual graph. The legend, font, title, etc won't chang