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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding a Dynamic Range
Hello, I have an ever changing range I would like to get a handle to in excel VBA. It always starts at H2, but can end anywhere e.g. I4 or AQ156. Does anyone know how I get a handle to the range from ("H2: [possibly anywhere]") ? Stacey- walkest
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Save As Dialog (with FilePath and FileName suggested)
Hi, I need to show the SaveAs dialog (in VBA) and pass 2 arguments into it. E.G. I want to show the SaveAs dialog with the suggested FilePath pointing to "T:\IMPORT" and the suggested FileName as "[TodaysDate]_Export". NB: I don't wish to proceed with the Save automatically...- walkest
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
