ilyaskazi
03-25-2005, 07:42 AM
macro required for adding data in cell for the selected ranges.
For Example:
1) Preceed = "NEW" for the foll cells..
YORK
DELHI
BOMBAY
CAR
Output:
NEWYORK
NEWDELHI
NEWBOMBAY
NEWCAR
2) Append = "PHONE" for the foll cells..
MOBILE
CELL
SMART
SATELITE
Output:
MOBILEPHONE
CELLPHONE
SMARTPHONE
SATELITEPHONE
While executing it should ask user containing 2 txtboxes in userform for preceeding and appending data for the selected range to manipulate.
For Example:
1) Preceed = "NEW" for the foll cells..
YORK
DELHI
BOMBAY
CAR
Output:
NEWYORK
NEWDELHI
NEWBOMBAY
NEWCAR
2) Append = "PHONE" for the foll cells..
MOBILE
CELL
SMART
SATELITE
Output:
MOBILEPHONE
CELLPHONE
SMARTPHONE
SATELITEPHONE
While executing it should ask user containing 2 txtboxes in userform for preceeding and appending data for the selected range to manipulate.