RGButzArchInc
New Member
- Joined
- Aug 16, 2009
- Messages
- 24
Usng VBA I wouldl ike to convert a date (string) to a serial number. I want to manipulate the number(s) arithmeticaly. The code in question is in a for next loop. i.e.
Current_Aspect -= Range("U & i")value.
I have tried using various funtions, both excel (application.value, etc) and VBA functions.I have also tried manpulating the data type to no avail. Any and all advice is greatly apprecited.
Current_Aspect -= Range("U & i")value.
I have tried using various funtions, both excel (application.value, etc) and VBA functions.I have also tried manpulating the data type to no avail. Any and all advice is greatly apprecited.