ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 Problems; in wrinting a macro and convert text (https://www.excelbanter.com/excel-discussion-misc-queries/123530-excel-2007-problems%3B-wrinting-macro-convert-text.html)

bezl

Excel 2007 Problems; in wrinting a macro and convert text
 
Hi,
in excel 2007 if macro name contains number (e.g. "sub gel06(value)") macro
does not work, why.
And in Text to Colums decimal and thousands seperator isn't converted to
excel seperators altough needed adjustments is made, why.
Thanks advance for your help...

Bob Phillips

Excel 2007 Problems; in wrinting a macro and convert text
 
It is probably because GEL is a valid column in 2007, so GEL06 could be seen
as a cell.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"bezl" wrote in message
...
Hi,
in excel 2007 if macro name contains number (e.g. "sub gel06(value)")
macro
does not work, why.
And in Text to Colums decimal and thousands seperator isn't converted to
excel seperators altough needed adjustments is made, why.
Thanks advance for your help...





All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com