Hi,
I am wondering if anyone would be able to help with copying a workbook of excel tables and charts into PPT?
I was able to get the code to work to copy the table (range D3 to V21) into ppt, however, when I added in the following code I got a Compile error (invalid Next control variable...
Hi there,
I have a macro that will transpose data from the 'test' tab to the 'result' tab. Data in the 'test' tab are numbers -1000 to 1000 with 5 decimal places. The macro will take the table format in 'test' tab and tranpose into column format that used to be import into databases.
This...
Hello,
I am trying to write a simple add item query to a combo box. Below is my code:
With Sheet1.ComboBox1
.AddItem "Paris"
But I keep getting a Compile error: Method or data member not found.
I suspect it's something wrong with the ComboBox1 "code function". Usually when I start...
Hello,
I have a model that display regional forecasting information on one summary tab. In the first tab of this model, I created a combox box to allow user to pick which region (from a list of 50 regions) they want to view, then on the summary tab, they would see a chart and a summary table...