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.
iSheetA.Offset(2, 6).Value iSheetA.Offset(2, 6).Text