difference between range.text and range.value
I just found a difference (probably not a surprise to other
responders) but when reading cell values, range.text is limited to
1024 characters. Just had a cell with 6400+ characters (a distribution
list) and the len of range.text was 1024! Used range.value to get the
entire string into a variable.
Cliff Edwards
|