Edit Cell Macro

  • Thread starter Thread starter Tyler McLean
  • Start date Start date
T

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
 
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
 
Back
Top