Search results for query: *

How would you sort entire rows alphabetically based on the values of Column B ? I must be missing something very simple, my range of data gets completely messed up when I try. only the selected column will sort and the rest of the range does not. Steve

Greetings How would you prevent Debug mode from popping up if an UNEXPECTED error occured during a macro function? I would rather have the user see an error msg pop up telling them an error occured which stopped the function than have the debugger appear and let them guess and maybe try to...

XLBO, How would you code this if you wish to check a specific cell from an activerow against a column range from a different sheet? Example, I wish to change the color of Sheet1 ActiveRow column 5 only if the same value exists anywhere in Column 3 of Sheet2? Thanks Steve

How would you insert a comment into a cell based on data from another worksheet?

Greetings I would like to be able to click a button on a worksheet, open a form or dialog which the user then inputs; First Name ' destination cell=(1, newcolumn) Last Name ' destination cell=(2, newcolumn) Address ' destination cell=(3, newcolumn) phone ' destination...

Thanks M. Smith Yes I would like to see a demo workbook. My email is Aurbo@shaw.ca

Greetings I require the following miracle to happen via a button on a worksheet or clicking a specified cell; Step 1. click on cell or button located in worksheet1 cell F3 Step 2. copy worksheet1 cell f1:f2 to worksheet2 cell a1:a2 Step 3. confirm worksheet1 cell a4 is not empty if...