Edit Cell Macro

[Tyler McLean]

I need to create a macro to edit the contents of a cell and put quotes
around it.
For example: car ---> "car"
The contents of the cells will be both numbers and words.
I would need to use this format on everything in the spreadsheet in order to
import this into another program.


Thanks,
Tyler
tmclean79 at shaw dot ca

 

[Mike Hughes]

Tyler

One way.

Create a button and assign the code below.

Sub Button1_Click()
whatsthere = ActiveCell.Text
ActiveCell.Clear
ActiveCell.Value = Chr(34) + whatsthere + Chr(34)

End Sub

select a cell and click the button. Making it work on multiple cells is more
difficuly but if I understand the question yoo don't want to do that.

Mike

 

[Otto Moehrbach]

See my response to your later post. Otto