Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
tranfere vertical data to horizontal tabel | Excel Worksheet Functions | |||
Search/Filter to find values in another range based on two cell values | Excel Programming | |||
Copy values from file A, Find/Replace these values in File B | Excel Programming |