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...
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 =...
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"...
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é
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...
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...
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é
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.