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!

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

Search results for query: *

  1. azzi2000

    Excell: try to find if anydata exists in sheet

    how can I do that, I use Cell.select but do not know how to use the count ? Please advice, Thank you Dré
  2. azzi2000

    Excell: Data definition based on 2 columns ?

    Can I define data definition to show drop down list of 2 columns ? I am uing Define name and would like to show 2 column user drop down listing. Please advice, Thank you dré
  3. azzi2000

    Excell: try to find if anydata exists in sheet

    This should be simple. I am importing outside data to a spreadsheet SheetOrg, then based on some criteria I distribute data from SheetOrg to sheetA,sheetB, sheetC... After All done I want to erase sheetOrg if nothing is in it or Display a warning message for data failure if data exists in...
  4. azzi2000

    Excel: simple question for repetitive Or's

    There must be a simpler command to find match for a numerous conditions. I have the following code: if ws.name = sSheet1 Or ws.name=sSheet2 or Ws.name=sSheet3.... there must be something like this: if ws.name in (sSheet1, sSheet2..) then .... Please advice, Thank you. Dré
  5. azzi2000

    Excell: Copy specific sheet in excel without opening Excel file

    Is it possible to copy a specific sheet(SheetPrice) in excel without opening the file to another workbook. (this workbook is open) This is what I am trying to do: Dim WB1 As Workbook, WB2 As Workbook Set WB1 = ActiveWorkbook 'Current One Set WB2 =...
  6. azzi2000

    Excel: Find all, select, copy the selection to another sheet question

    I think this would be the best approach applying filter. Thank you all for the responses Tahnk you. Dré
  7. azzi2000

    Excel: Find all, select, copy the selection to another sheet question

    Simmy: I am trying to get around the loop row by row. Thanks anyways, Dré
  8. azzi2000

    Excel: informative Form blank while processing macro

    I am using a long macro to process the steps. However I need to inform the user the steps via window that Are taken. (ie: Step 1 of 5....) I am using a Form to show the steps while executing Macro: MyForm.show vbModeless Myform.Caption = "Download" MyForm.lblmessage = "Please Wait - Step 1 of 5"...
  9. azzi2000

    Excel: How to turn off the macro process steps

    I have a long macro that keeps on shifting between one sheet select copy.....to another sheet. I need the process to be invisble to the user and instead place a message msgbox "Please Wait - Processing" until the pocess is done. Please advice, Thank you. Dré
  10. azzi2000

    Excel: Find all, select, copy the selection to another sheet question

    Is there a command in Excel to copy all the rows that it meets a find criteria (similar to find All) and copy/paste them to another sheet. I have it coded in a loop to find one by one then copy paste... My pseudo code is somthing like this: (pseudocoded) Do sheet(1).select...
  11. azzi2000

    Excel: Macro to set validation data list

    This is what I am trying to accomplish: --- pseudocode Define RangeRate Where ColumnA = Rate1 (next loop Rate2..) Range("A6").select Set the validation List based on RangeRate ---- Column1,Column2 Rate1, 5/1, 4 Rate1, 5/2, 4.5 Rate1, 15 , 5.8 ... might have more column with Rate1 ... Rate2...
  12. azzi2000

    Excel: Simple macro setting formula question

    How can I get the value of that cell. nQty=Cells(r, "E").Address(False, False).Value but it is not working. - Also where Can I get a help file withing excel to learn. Thank you. Please advice, Dré

Part and Inventory Search

Back
Top