Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to re-write all cells in a column
Bob
It should be possible. "re-write all the contents" means what? What do you have now and what do you want to see after "re-writing"? Do you want to add to the existing data or put new and unique data in the cells? Gord Dibben Excel MVP On Tue, 10 Aug 2004 13:45:03 -0700, "Bob L" wrote: I would like some help writing a macro to rewrite all the contents of the cells for an entire column. Is this possible? Thanks for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to re-write all cells in a column
Gord,
I have both text and numbers, I want it to just rewrite itself. I am using a vlookup formula that won't work unless I rewrite the cells in the lookup column and I can't figure out any other way but to rewrite the contents. Bob "Gord Dibben" wrote: Bob It should be possible. "re-write all the contents" means what? What do you have now and what do you want to see after "re-writing"? Do you want to add to the existing data or put new and unique data in the cells? Gord Dibben Excel MVP On Tue, 10 Aug 2004 13:45:03 -0700, "Bob L" wrote: I would like some help writing a macro to rewrite all the contents of the cells for an entire column. Is this possible? Thanks for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to re-write all cells in a column
if you have numbers being treated as text, select the entirecolumn and
format as General, then do Data=Text to columns, select delimited, and click OK. (if you have commas in your data, select a delimiter like # that doesn't exist in the data). This should cause you data to be reevaluated. -- Regards, Tom Ogilvy "Bob L" wrote in message ... Gord, I have both text and numbers, I want it to just rewrite itself. I am using a vlookup formula that won't work unless I rewrite the cells in the lookup column and I can't figure out any other way but to rewrite the contents. Bob "Gord Dibben" wrote: Bob It should be possible. "re-write all the contents" means what? What do you have now and what do you want to see after "re-writing"? Do you want to add to the existing data or put new and unique data in the cells? Gord Dibben Excel MVP On Tue, 10 Aug 2004 13:45:03 -0700, "Bob L" wrote: I would like some help writing a macro to rewrite all the contents of the cells for an entire column. Is this possible? Thanks for your help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to re-write all cells in a column
Tom,
That reevaluated the text but it did not recalculate, which is what I think it needs to do. I have checked my settings under the calculation tab and all is o.k. I don't know what is causing this not to work but I am completley frustrated. I can go to the cell and retype the contents manually then go to my sheet that has the VLOOKUP formaula and the cell is filled in properly. Any other ideas? Bob "Tom Ogilvy" wrote: if you have numbers being treated as text, select the entirecolumn and format as General, then do Data=Text to columns, select delimited, and click OK. (if you have commas in your data, select a delimiter like # that doesn't exist in the data). This should cause you data to be reevaluated. -- Regards, Tom Ogilvy "Bob L" wrote in message ... Gord, I have both text and numbers, I want it to just rewrite itself. I am using a vlookup formula that won't work unless I rewrite the cells in the lookup column and I can't figure out any other way but to rewrite the contents. Bob "Gord Dibben" wrote: Bob It should be possible. "re-write all the contents" means what? What do you have now and what do you want to see after "re-writing"? Do you want to add to the existing data or put new and unique data in the cells? Gord Dibben Excel MVP On Tue, 10 Aug 2004 13:45:03 -0700, "Bob L" wrote: I would like some help writing a macro to rewrite all the contents of the cells for an entire column. Is this possible? Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
write a macro for variable cells | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Macro to re-write all cells in a column | Excel Programming | |||
Write a macro to populate a column with a formula | Excel Programming | |||
Write a macro ro copy column at certain time of day. | Excel Programming |