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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding the end of data
If you are simply looking for the last used row, you use the folowing script: activesheet.usedrange.rows.count Bob- ibbguy
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Reading csv files
This is okay if your values are all numeric, e.g., each line does not contain quoted strings (with or without embedded commas.) However, in conjunction with a read routine, you could pass each line of input (result of ReadLIne) to this function, along with the column you want extracted (1, 2...
