MARCO to import text by selecting columns
-----Original Message-----
Hello everyone, i have a macro that imports a text file and i have to manually run the wizard to select my columns. The text imports 5 columns and i have predefined the Marco to copy it to cell Set DestCell = Range("C1:E119") it works well, but i will like the macro to only select this range, without me manually skipping the first and last column before importing the text file. the information i need for the text files are in three middle columns. and the first and last columns are not needed.. Thanks in advance . |
All times are GMT +1. The time now is 06:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com