Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find, cut, and paste entire row
Howdy. Based on the value of an ID number scanned into an input box,
I would like VBA to search for it on one column on one worksheet, then if found cut the entire row and paste it to the end of a list on another worksheet. I currently find the ID number using this method: myvalue = Columns("H").Find(InputBox(PPID)) Works great, but I can't figure out how do determine what row this is found on. If I knew that, I would attempt to cut or copy the entire row. Any clues? John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy and paste an entire workbook? | Excel Worksheet Functions | |||
Find Multiple Values, Copy Entire Row & Paste | Excel Programming | |||
Find/Copy/paste.. then Find/Paste - not working ... at all.... | Excel Programming | |||
Cut and Paste entire row from one worksheet to another | Excel Worksheet Functions | |||
Cut and Paste entire row from one worksheet to another | Excel Worksheet Functions |