Range problems with my macro...

[Jim Cone]

silas,
Replace the range designation with "Selection" - no quote marks.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"silas" <[email protected]>
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

 

[silas]

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

 

[silas]

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