help with a logic test
I need a logic test to run in a macro. I have a colum where alot of the cells start with a number and at some point probably 200 rows down the data starts with a letter, like below
123456
234567
3456789
123789
a123asd
avb456
aeb456
I want the logic test to find the end of this list and cut out that part so that the macro can paste it to another sheet. Is this possible?
Maybe something like this:
Please Login or Register to view this content.
This assumes there will always be a row starting with a letter.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
OK, here's some code that looks down a list in column A of the first sheet until it finds a cell with data that starts with a letter. It then gets everything from there down to the end of the list, cuts it out of the first sheet and pastes it at the top of column A of the second sheet.
Please Login or Register to view this content.
.... I spent about 3 hours trying to figure this out, and nothing... thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks