Hi I have a couple of quick questions; 1) can the print command be used to form text files (like it can be for html files). 2) I have a list of data that is imported into excel vba textboxs . atm using; range('A1').Select ActiveCell = Textbox 1 etc etc However, when ever I use CurrentRegion Select, or xlUP etc, if any of the textbox cells are blank they are still selected, is there any way around this? Cheers Dan

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Print command - text files as well as html?

Thread starter dantheman9
Start date Feb 22, 2011

dantheman9

Board Regular

Feb 22, 2011

Hi I have a couple of quick questions;
1) can the print command be used to form text files (like it can be for html files).
2) I have a list of data that is imported into excel vba textboxs . atm using;

Code:

range('A1').Select
ActiveCell = Textbox 1
 
etc etc

However, when ever I use CurrentRegion Select, or xlUP etc, if any of the textbox cells are blank they are still selected, is there any way around this?

Cheers

Dan