get external data go the wrong range

[smatbis]

hello again all

i have macro to get external data from text file

the problem is it doesnt paste the data into the correct range

it supposed to fill in the range b3:e13 , instead of that , it goes to range b4:e14

refer to my attachment , tq

[sktneer]

That's because somehow the first character in your text file is hidden line feed character i.e. just before the character B.
If you open your text file, place the cursor before B and hit the backspace key, it will delete that and then save the text file and run your macro you will get the desired output.
Import the data from the attached Text file and see if that works as desired.

[smatbis]

That's because somehow the first character in your text file is hidden line feed character i.e. just before the character B.
If you open your text file, place the cursor before B and hit the backspace key, it will delete that and then save the text file and run your macro you will get the desired output.
Import the data from the attached Text file and see if that works as desired.

thanks sir for the explanation