Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Set myrange not being recognized
Hello and thanks in advance for your help. Having troubles using the Set myrange = Worksheets("LineHours16").range("C2:C500"). This is used for lcount which counts the number of rows equal to line value. I had this working yesterday morning, but it's not working anylonger. Here is the code...- dstilson
- Thread
- Replies: 13
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Open Access using Excel and run Macro
Hello, I have a excel macro set up to launch Access using the Shell command and then I want to run a macro in Access. This works fine under office 2003, but does not work under 2007. I get and error "Object Required" on the DoCmd.RunMacro "mcrShipReq". Here is what I have: Dim appTraffic...- dstilson
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Charts - Conditional Formatting
I am trying to chart a MTD and YTD series of data, but want the fill format for stacked bar chart to change based on a formula. The colors I'm using are Red, Yellow, and Green. I can get the first series to work under a stacked chart, but when adding the second series I'm having difficulty. I...- dstilson
- Thread
- Replies: 6
- Forum: Microsoft: Office
