Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best Practice
I have a macro that loads data from another workbook when a button is pushed.
Currently it only pulls data in from one cell using the following lines of code: With Sheet23.Range("A1") .Formula = "= '" & module1location & "sheet2'!A3" .Formula = .Value End With Shortly, I am going to be pulling in a lot more data from different cells from "module1location". Is this the best way to be doing this? Seems like I remember someone saying "don't fix what ain't broke..." Thanks for any help, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help panel won't go away after saving a practice sheet | New Users to Excel | |||
Question re best practice | Excel Worksheet Functions | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
Excel practice sheet. Can't view instructions. | Excel Discussion (Misc queries) | |||
best practice? | Excel Discussion (Misc queries) |