2010 - vba

I am trying to figure out if there is a “VBA” way I can return a value from an “ADJACENT” formatting color cell. All the place headers are adjacent to yesno headers. Column K is a place value, column L is the formatting color values Column N is a place value, column O is the formatting color...

Hello, I would like to know if there is a way to automatically update the content of a cell based on the value of a cell in another sheet ? That original cell's value is based on a drop down menu. Could someone exlpain to me how to make it work ? Thank you very much for your help

Hello, I have a VBA macro that re-formats an Excel Chart (in a separate tab) for specific specific chart area that works in 2007. ActiveChart.ChartArea.Select With Selection .Top = 0 .Left = 0 .Width = 745 '735 .Height = 530 '530 .Border.LineStyle =...

In an excel 2010 workbook (which I test on a local 2013 version) i have run into the following problem. After creating a workbook(wb) i need to then close it without saving. To do this i change DisplayAlerts to false and then back to true after closing. This works as intended for when I...

Hello, I am trying to write a few lines in vba to give me the number of items in a Pivot Dropdown (in this case, I want to know how many options there are under "Pay Period" which allows me to check multiple items and display multiple weeks of data) I will be displaying the last 4 Pay Periods...

The code below allows me to input a complete picture file name into cell (A2), press the “Refresh” control button, and the picture from the file name is displayed. Each time the “Refresh” button is clicked, it clears the current picture and refreshes the picture from the file name referenced in...

I have a macro that went from running in 1-2 minutes in 2003 to taking 35-40 minutes in 2010. I have been trying to figure out what is causing the slow down. I think I have narrorwed it to this section of code. Public Property Get StartRow(sheetName, TextValue, Optional theOccurrence As...

I have a bank of user defined functions (UDF's) which I keep in the personal.xlsb workbook. I used to run Excel 2003, and the same functions worked fine both in the personal.xlsb and main worksheets. In Excel 2010 I can use them in the personal.xlsb workbook when it is unhidden, but cannot do...

Good Day! This should be an easy one. I am attempting to resize a set range to include data that was split and transposed so I can split it again. However I am receiving "Application-defined or Object-defined error." I'd appreciate anyone's assistance in pointing out what I missed and any...

Hello, I am needing assistance with PivotCaches. I am including code below that is intended to have access export qryExport to excel, then the code is supposed to create multiple pivots on the Pivots sheet based on the qryExport. I have gotten it to work a couple times, but not consistently...

I have the following code I am trying to execute. If I debug.print sCommand I can copy and paste it in a cmd window and it will execute. But it will not work in VBA unless I take out the >\\.....\log.txt portion. It's like trying to make a log file breaks it. Can someone help me figure out...

Hi , My problem is not easy to describe but I will try to be as simple as possible. I import a csv file into Excel but the csv is not filtered. Depending on a value in Column B, I would like to re-order the column D to AL. In the attached file, for example, for all value in column B = 113, I...