Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations IDS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Anerol

    Check if Sheet exists

    But where do I specify the name of the sheet to look for?
  2. Anerol

    Check if Sheet exists

    Hi, I'd like to write a macro that checks to see if a certain sheet already exists. If it doesn't I want it to create the sheet, and if it does, then move on. HELP ME PLEASE!!!
  3. Anerol

    Selecting a column

    I have a fairly simple problem, I think... I have a sheet containing 10 different columns. In a macro, I specify it to look for a "project manager" which is the title of the column. When it finds it, I want it to select the entire column and delete it, shifting everything to the left. The...
  4. Anerol

    Comparing columns

    Hi there, I'm trying to find a way to compare 2 columns that I have. In col A I have 233 numbers and in col B I have about 300 entries. I'm trying to see if any of my numbers in col A match any number in col B. I'm trying to do a simple IF statement... something like if(A1 = B1:B300, true)...
  5. Anerol

    Flipping columns in Excel

    How do I flip a column. I don't mean to transpose from row to column or column to row, but say I have an array A1:A14, I want the values in A14 to be in A1, A13 in A2, A12 in A3, and so on. How do I do this??? thanks.
  6. Anerol

    CFtool not Plot!!!

    Hi there, I am trying to plot something in the curve fitting toolbox instead of plot. I created a fit for my curve called it trans_gauss Then I called cftool -- cftool(x,y) but when I say -- plot(trans_gauss) it plots it in a basic graph instead of the curve fitting toolbox! And there is no...
  7. Anerol

    colordef

    Hi Kolaps, I was wondering if you could tell me what you did. Thanks. Anerol
  8. Anerol

    Delete NaN Values

    My matrix contains NaN values. How do I create a new array from my matrix without including the NaN values? Help! Thank you thank you =)

Part and Inventory Search