Hmm my code seems to be playing up, any ideas...
So basically the code below is to help me automate a repetitive task.
However for some reason the only part not working as it should is the function where it changes K column from TRUE/FALSE to 1/0 accordingly...any ideas.. Thanks
Please Login or Register to view this content.
Last edited by mrebzz; 04-19-2024 at 03:16 PM. Reason: Update
One in quotes (i.e., "1") is a character, not a number. "TRUE" in quotes is a character string typed in manually, not the Boolean result of a formula. I don't know which you are dealing with since there is no sample file
Please Login or Register to view this content.
Last edited by protonLeah; 04-19-2024 at 04:02 PM.
Ben Van Johnson
Correct
I am just basically cleaning some excel data.TRUE (text, Capitals) i just want this to be changed to the number 1. again this can be a string .. its irrelevant in this :D haha thanks for all the help
Or, seeError handling for text values in a column.Please Login or Register to view this content.
Or without the loop:But will convert the text to an error value.Please Login or Register to view this content.
Artik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks