Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by scottscott

  1. scottscott

    Evaluate String Path as value

    Thanks a lot Skip! I would have never been able to figure that out. I just read up on all the Function keys. I always forget about those. Strongm, I tried the indirect function earlier but wasn't able to get the string to evaluate. Of course you could use the F9 trick that skip just showed...
  2. scottscott

    Evaluate String Path as value

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

    Paste Excel Range into Powerpoint

    Can anyone think of a way to paste an excel table into powerpoint? I already have the completed table in excel. Would be nice to avoid recreating the table by looping through each row and column.
  4. scottscott

    Using a variable in a regular expression

    rel.Pattern = Lc & "[a-z]" are a and z variables
  5. scottscott

    Paste Excel Range into Powerpoint

    The Range I am trying to paste is at the very bottom Sub convert2pre(Optional x As Boolean) 'Eli Scott '1/20/2012 'This Macro generates a powerpoint file for the experiment results 'Dim XLApp As Excel.Application Dim wSheet As String Dim ws As String Dim pptApp...
  6. scottscott

    Paste Excel Range into Powerpoint

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

    Determining Line Color for Excel graph

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

    Deleting Graphs from a Worksheet

    Thanks skip did exactly what I needed.
  9. scottscott

    Deleting Graphs from a Worksheet

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

    Navigating while userform is displayed

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

    solver

    Thanks just what i wanted!
  12. scottscott

    solver

    'Solve Aexp(ct^B) SolverOk SetCell:="$E$2", MaxMinVal:=2, ValueOf:="0", ByChange:="$E$1:$G$1" SolverSolve 'Solve for the half life SolverOk SetCell:="$K$1", MaxMinVal:=3, ValueOf:=".5", ByChange:="$I$1" SolverSolve After each SolverSolve a dialog box pops up.
  13. scottscott

    solver

    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?
  14. scottscott

    Adding Data to a range

    I was afraid of that. Thanks Skip!
  15. scottscott

    addressing a userform textbox via a loop

    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?
See more

Part and Inventory Search

Back
Top