Hi
I have a problem with my macro, sometimes it splits a number which is delimited with "." into two cells. For instance, 0.6888, becomes 0 in column A and 6888 in column B. Anyone who knows how to avvoid this problem? My excel uses comma normally as delimiting into decimals.
Please Login or Register to view this content.
Last edited by Hjahren; 10-29-2010 at 06:56 AM.
Have you previously used either the import wizard or the Text to columns facility and specified '.' as a delimiter?
Everyone who confuses correlation and causation ends up dead.
No, the coding displayed earlier is the first part of importing into the excelsheet.
I have also checked that the text to columns delimited with "." is unchecked on forehand
Well, since your macro doesn't actually put the data into Excel, it's not really relevant. I suspect the method you are using to Paste is responsible.
Do you have any idea to get rid of the problem?
If it works sometimes, I would have to assume that you are doing something beforehand that involves parsing text.
I don't do any parsing in this spreadsheet or this macro. But sometimes in other macros. But then comma delimited, and not dot delimited.
If you do parsing in the same Excel session (regardless of workbook) then it can affect subsequent pasting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks