Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel2000: Formatting a range as Text in VBA
Hi
To format a range as General in VBA I use a code row like this: .... ThisWorkbook.Sheets("Forecast").Range("A1").Offset (k, 2).NumberFormat = "@" I have searche desperately for it, but I didn't find a way to set the range to be formatted as Text (i.e. after the VBA formats the range, cell format shows it formatted as Text). I tried to record a macro when formatting the range as text manually, but all I did get back, was the same code for setting format to General Thanks in advance for your help! -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel2000: Formatting a range as Text in VBA
Hi Arvi,
To format as general: Selection.NumberFormat = "General" To format as text: Selection.NumberFormat = "@" --- Regards, Norman "Arvi Laanemets" wrote in message ... Hi To format a range as General in VBA I use a code row like this: ... ThisWorkbook.Sheets("Forecast").Range("A1").Offset (k, 2).NumberFormat = "@" I have searche desperately for it, but I didn't find a way to set the range to be formatted as Text (i.e. after the VBA formats the range, cell format shows it formatted as Text). I tried to record a macro when formatting the range as text manually, but all I did get back, was the same code for setting format to General Thanks in advance for your help! -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel2000: Formatting a range as Text in VBA
Thanks!
-- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Norman Jones" wrote in message ... Hi Arvi, To format as general: Selection.NumberFormat = "General" To format as text: Selection.NumberFormat = "@" --- Regards, Norman "Arvi Laanemets" wrote in message ... Hi To format a range as General in VBA I use a code row like this: ... ThisWorkbook.Sheets("Forecast").Range("A1").Offset (k, 2).NumberFormat = "@" I have searche desperately for it, but I didn't find a way to set the range to be formatted as Text (i.e. after the VBA formats the range, cell format shows it formatted as Text). I tried to record a macro when formatting the range as text manually, but all I did get back, was the same code for setting format to General Thanks in advance for your help! -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2000:How to link Print Area with a named range | Excel Worksheet Functions | |||
Excel2000: UDF's parameter as cell range OR array | Excel Programming | |||
Printing date range in excel2000 | Excel Programming | |||
Excel2000: Reading Named Range value from VBA | Excel Programming | |||
Excel2000: finding last row of used range | Excel Programming |