View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
evgny evgny is offline
external usenet poster
 
Posts: 10
Default Find and tranfere values

Hi
I use find, findnext and search in a difrent workbook and when i got the
addresse I need to get non-contiguos cells values and past/transfer to
the active worksheet, I am usige
rngA = c.address
rngF = "F" & mid(c.address,4)
activecell = workbooks("A").range(rngA).value
activecell.offset(0,1) = workbooks("A").range(rngA).value, but is there
quiker methode to do this.

regards evgny