Range problems with my macro...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

silas - 12 Apr 2007 04:04 GMT

I'm trying to create a macro for the following actions: select several
contiguous rows of data; click Data/Text to columns; select Delimited, Other
and enter "$"; select Finish; then return to Text to columns; select Fixed
width for the remainder of the data and Finish. My problem is when I run the
macro it only effects the original range of cells and I can't figure out how
to get it to work for any range I select.

Appreciate your help.

silas

Reply to this Message

Jim Cone - 12 Apr 2007 04:05 GMT

silas,
Replace the range designation with "Selection" - no quote marks.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"silas" <silas.NOSPAMprophet@gmail.com>
wrote in message
I'm trying to create a macro for the following actions: select several
contiguous rows of data; click Data/Text to columns; select Delimited, Other
and enter "$"; select Finish; then return to Text to columns; select Fixed
width for the remainder of the data and Finish. My problem is when I run the
macro it only effects the original range of cells and I can't figure out how
to get it to work for any range I select.

Appreciate your help.

silas

Reply to this Message

silas - 12 Apr 2007 05:08 GMT

Jim,

Thank you, that's pretty close to what I want. It worked- to a point- and it
made me realize a flaw in my objective.

Thanks again.

silas

> silas,
> Replace the range designation with "Selection" - no quote marks.

Reply to this Message