Double check your spelling and symbols on the line of code that produces the
error. There is no reason for the error, otherwise.



"Excel Curious" wrote in message
...
The data I'm working with is from a .txt file which was created by
exporting
a .pdf to a text file.

I copy all of the text from the .txt file and paste it into a column in
Excel.

When trying to reference any column, row, or range on the sheet with the
pasted text, I get the following error: Run-time error '1004':
Application-defined or object-defined error.

Sample code:
Sheets("Sheet5").Select ' <this works fine
Columns("A:A").Select ' <this gets the error

I've tried pasting the text with other paste special options. I've tried
referencing the text on another sheet and running the code off of it. I've
tried using the Text formula to reformat the text. But, none of this seems
to
be working. I cannot select any area on a sheet that has or references
this
text... and therefore cannot use it in my code.