I am using a Vlookup macro to compare over 4000 cells and when it runs it reformats the entire column from numbers to text.
Is there a way to make excel not do this? My code never references the numbers as text so I can't figure out why it's getting reformatted.
Post the workbook / code so someone can take a look. Using the VLOOKUP function inside VBA will, itself, not cause formatting issues. Seems, either the cells in the column are formatted as text or there is other code formatting them as such.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Fixed the issue. What happened was Vlookup was referencing the numbers as text while the other excel sheet I was using referenced it as integers. I added INT(cell) function and everything fell into place.
Thanks for your help though Palmetto!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
swaink 
Register To Reply
Bookmarks