VBA snippet copy and dump

Set wbOpen = ActiveWorkbook wbOpen.Worksheets(1).Range(“A1:Q5000”).Copy ThisWorkbook.Worksheets(“dump”).Range(“A1”) wbOpen.Close Related posts: Edge Media Edge Media is an online-learning provider based in Cape Town…. Tree App The Tree App project was run from Johannesburg using a… VBA snippet time your code This is a useful little runner to compare two techniques… Data Are…

read more

VBA snippet time your code

This is a useful little runner to compare two techniques to verify which is fastest.   Related posts: Edge Media Edge Media is an online-learning provider based in Cape Town…. Tree App The Tree App project was run from Johannesburg using a… VBA snippet copy and dump Set wbOpen =…

read more

Tree App

The Tree App project was run from Johannesburg using a remote team – data and project management was carried out with cloud, with the majority of data held on Google Drive. If you are looking at the future of work;  bringing in people on projects as needed – employing freelancers…

read more

Edge Media

Edge Media is an online-learning provider based in Cape Town. We were contracted to provide a reporting solution: Data management of Excel held data Edge process a large volume of exam results for their students. They required a VBA solution to collate this data for reporting purposes. The data structure…

read more