VBA Select Dynamic Range

Hi All,

Can you please show me how to edit the following code below to pick a dynamic range from a fixed cell e.g. "B2". This is copying data from a workbook “Project” to another workbook “Comply”.

My data range will change in row lengths but columns are always fixed e.g. fixed from column B to E AND will always start at column “B2”.

Can I please have a code that only picks a range offsetting from “B2” to the last cell before the blank cell in column B.

This data is then pasted onto workbook “Comply” active sheet cell F2.


My code is as follows:

Please Login or Register  to view this content.