Recent content by azzi2000

I though so Thank you. Dré

thank you. Dre

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

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é

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

Thank you. Dré

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é

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

Thank you Dré

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

.repaint did it Thank you. Dré

Thank you Dré

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

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

Perfect. Thank you.