Recent content by GovNewbi

nope it still takes the whole thing and makes it superscript????

This dosn't seem to be working... here is the code I have ActiveChart.Axes(xlValue).AxisTitle.Select ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "Volume (106m3)" ActiveChart.Axes(xlValue).AxisTitle.Characters(Start:=11, Length:=1).Font.Superscript = True...

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?

it works now... I don't know why because I haven't changed a thing but it is now running correctly. Thanks anyway

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 -...

YES the filtering worked!!! It actually solved all the cosmetic problems I was experiencing! THANK YOU!

I have a feeling this is over my head cuz that was like a foreign language to me lol.

k... i'm not sure how to address that.

The four graphs vary a little but here is the general idea. This isn't the whole code but I think this is the piece the problem is in... ActiveChart.ChartType = xlColumnStacked ActiveChart.SetSourceData Source:=Range("Graph2Area") ActiveChart.SeriesCollection(1).XValues =...

yes i know this is the problem what i don't know is how to fix it lol

Ok as an overview of my program the user inputs all sorts of information, that info goes into one table. The macro reads this table and formats a second table. There can be one of four formats depending on the user input. The macro then populates this table pulling information from other...

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...

Thanks guys it worked great... I have one more question kind of related to this. When the list box opens the second time the items that were selected the first time are still selected. Is there a way to have it not select any when it opens or to just highlight the top one or something like that.

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?

perfect thanks guys :)