Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
place content of variable in destined cell in previous worksheet
Hi
I get an error message in the line Cells(x, 3).content = res I want to place content of res in cellls (x,3) in previous worksheet How do I do that?? Sub test() Sheets("makro").Activate ActiveSheet.Previous.Select x = 5 Do While Cells(x, 3).Value < "" res = Application.vlookup(Cells(x, 3), Worksheets("P&Ltot").Range("A1:G50000"), 7, False) Cells(x, 3).content = res x = x + 1 Loop End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
place content of variable in destined cell in previous worksheet
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete previous cell content | Excel Worksheet Functions | |||
List items determined by content of previous cell | Excel Programming | |||
Keyboard Macro Just Copies Content of Previous Cell | Excel Discussion (Misc queries) | |||
Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) | |||
how to place a variable cell into a range? | Excel Programming |