View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jaybird[_3_] Jaybird[_3_] is offline
external usenet poster
 
Posts: 30
Default 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