abenitez77
Board Regular
- Joined
- Dec 30, 2004
- Messages
- 149
I have a macro that runs and extracts data from the cells. I noticed that sometimes I have to use .Text and other times .Value. I started out with .Value but I had some problems with data that was being read so I had to use .Text. Is there a rule or best practice for using these 2? I am inserting the results into a SQL Server Table.
Thanks,
Alex
Code:
iSheetA.Offset(2, 6).Value
iSheetA.Offset(2, 6).Text
Thanks,
Alex
Last edited: