Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA Output to Excel: Using the range declaration with Chr()
I am trying to determine how the following code determines where to put the output in an excel spread sheet. The VBA code is written: j=68 Range(Chr(j) + "22").Select ActiveCell = G / 1000 I don't understand how the values inside the parentheses following "Range"...- dougez
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
VBA Output to Excel Using the Range command with the Chr() function
I am trying to determine how the following code determines where to put the output in an excel spread sheet. The VBA code is written: j=68 Range(Chr(j) + "22").Select ActiveCell = G / 1000 I don't understand how the values inside the parentheses following...- dougez
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
