ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MARCO to import text by selecting columns (https://www.excelbanter.com/excel-programming/286285-marco-import-text-selecting-columns.html)

nilaja

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