View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jims Jims is offline
external usenet poster
 
Posts: 15
Default Set a column to "text"

I'm using Office 2007, using the Excel object model from Access VBA. I want
to select a column (say, column G), then turn it all to text. It may contain
mostly numbers, but I want Excel (and ultimately Access) to see the entire
column as text. There is a way to do this manually, but I need to do it
through VBA. Anybody got a quick code snippet they could share? I'd
appreciate it....

--
Jim