Search results for query: *

Is it possible to evaluate the below statement as a formula in a cell: = "=" & A1 & LEFT(A3,2) & "00 - " &LEFT(A3,2) & "99\[HIL " & A3 & " " & B3 & ".xlsx]Composition'!$L$1" Where A1 is a server location and A3 & B3 are just numbers. So the end result will look something like this...

I would like to replicate the effect of manually copying a range in Excel and pasting it into Powerpoint in Office 2007 as a Table that I could edit. I can't seem to replicate this behavior through VBA. I've looked though the forums and found a bunch of solutions that don't do exactly what I...

Hello, Is there a way to determine the color of a line in an excel graph? I would like to store the color of the first line which excel picks and then plot the second line with the same color as the first line. See below: 'JV plot With...

Hello, How would I delete all the graphs from a particular sheet without knowing the names of the graphs? Thanks, ScottScott

Is it possible to allow the user to navigate through worksheets while a userform is displayed? I need to allow the user to look through the worksheets in order to select the proper data on the userform.

I am using solver in a macro and after i run solver it always prompts to ask if the solution is okay. I would just like to accept the solution. I tried using Application.DisplayAlerts = False but i still get the prompt. Is there a way to click ok through vba?

Is it possible to access a userform textbox through a for loop? for i = 1 to 9 if myform.textbox1.value = 1 then 'perform task end if next i Is there anyway to replace myform.textbox1.value with myform.textbox(i).value?

I am trying to write a macro which will plot data from a text file. The data which i am trying to plot is in column B and it contains both x&y values: B x1 y1 x2 y2 The number of data points will always be different. I currently know the starting and ending points, but i am having trouble...

Is it possible to dissable the save as prompt when saving over an existing file? I am trying to write a macro that will open a data file paste it into a template and save over the existing template.

I am new to vba but familiar with various other programming languages like C++, assembly. I was wondering how i would go about making a browse button in an excel sheet that opens a file that the user would select, copies the data(columns A-E), pastes the data in the current excel sheet, and...