I am fairly low tier, but I have a minor issue with pulling from excel and am hoping someone can help out.
I am trying to pull a cell exactly as it is, not as it is visually represented. For example, the cell is 162.72, but the width of the cell is small and cuts it down to 163. How can I pull 162.72?
My standard copy/paste function is, but it rounds in this specific circumstance:
Code: Select all
Test1:= wrkbk1.Sheets(SheetName).Range("AV"ROW).Text
Code: Select all
Test2:= wrkbk1.Sheets(SheetName).Range("AU"ROW).Value
This is also a program used by less tech savvy people, so I need everything to function smoothly without further user input. As of now, the solution is to enforce them to make sure the spreadsheet they are using is sized accordingly, but less points of user error the better.