VBA – how to copy a range from one sheet to another using its name?
I need to copy a range from one sheet (every time the same range from the same sheet)
Excel VBA range does not return range
I am having problems with the range object in VBA – I expect the following code to have the range to be the actual range “A17” but it is actually the value in “A17”.
Excel VBA range does not return range
I am having problems with the range object in VBA – I expect the following code to have the range to be the actual range “A17” but it is actually the value in “A17”.
copy a range from one worksheet to another without blank rows
I have a range named in a worksheet that is five columns wide and approximately 220 rows long. The rows within that range are primarily formulas that pull data from other locations and concatenate or otherwise manipulate it. Some of the rows in the range are made up of cells that are entirely blank (no formula) or may contain a formula that returns no value.