Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba code cannot select text pasted from .txt file
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i select the coordinates of the first column & last row in a pasted range | Excel Programming | |||
Select Worksheet Where Data is Pasted | Excel Programming | |||
Code to Create Input Box To Select a File | Excel Programming | |||
carriage return that works when pasted into a text file (eg. Notep | Excel Discussion (Misc queries) | |||
Select text boxes code | Excel Programming |