Search results for query: *

Is there a way to have an excel chart's title contain numbers to an exponent? I want the title for the y-axis of my chart to have the units of measure which are cubic meters. Everytime I run my vb code the chart shows (m3). Is there a way to superscript the 3?

I have a program that copies four cells from one workbook and is supose to pastespecial transpose them into a row of a table in another workbook. When this piece of code executes... Set ws = ActiveSheet Set wb = Workbooks.Open("P:\ODD\OSD\BO\CARE Cost & Operations Forms -...

When my program generates a graph it reads the values in a cell range I have called "projects" and it uses these values as the labels along the x-axis. the problem is that "projects" is a column in a table and it can change sizes, when it does there are sometimes blank spaces that the program is...

When my userforms activate I have two listboxes in each that are being populated. The problem I am having is that a user may activate the form more than once and the listbox populates each time giving me duplicates. Where can I put the .AddItem code so that my listboxs are only being populated once?

Is there a way to lock the cells on a worksheet so that the user cannot change anything but still have a macro be able to go in and alter them without having to enter the password?

Is it possible to set a string variable equal to the value in several cells? I want this to work... Q1Titles = Range("Q1Titles").Value Q2Titles = Range("Q2Titles").Value Q3Titles = Range("Q3Titles").Value Q4Titles = Range("Q4Titles").Value Where Q1Titles is a range of 3 cells saying Jan, Feb...

in this piece of my code... Set wb = Workbooks.Open("Q:....xlsm") wb.Worksheets("MasterList").Range("I" & (Range("StProj").Offset(j, 0).Value) + 1).Copy There is something not right. The first line (Open) works fine, but once I get to the second line I get error 1004: range of object...

I need to know how to make this pop-up NOT pop-up! My macro opens and closes many files as it runs and extracts informaiton. I can't have this comming up each time. What do I do?

Ok so I am working in excel 2007 and I am trying to write a macro that reads a certain cell, if the cell is true it will divide all cells in a table I have created by a number found in another cell. There is one line in the code that will not run for me. I keep getting error 13. It looks like...

Sub Fetch3() Dim wb As Workbook Dim ws As Worksheet Dim CopyVal As String Dim SheetVal As Range Dim GTCell As Range Set CT = Range("CostType") Set CT2 = Range("CostType2") Set QRT = Range("Quarter") Set Yr = Range("StYr") Set GTCell = Range("GTCell") Set SheetVal = Range("CtCell") j = 0...

I have recorded a macro to generate a graph from a table that is filled with information from a userform. When I record the macro it gives the graph a name like "Graph 1" but then when I clear the info in the table and run the macro again it does not recognize the name "Graph 1" anymore. It also...

Ok so I am BRAND NEW to programming in vb and pretty much brand new to programming period (with minimal experience in C++). My job has me writing a program which I have been told is NOT beginner programming and I am very lost on a few items. If there is anyone out there who can answer a few...