CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course.
Here the FromRange can have more than one cell in width or height, while To1stCell should be 1 cell address.
Why? because the function will dynamically expand To1Cell to fit same width and height of FromRange.
Just like Copy and paste, but without using clipboard.


Public

Tested

My Own Work

FromRange, To1stCell, Optional FromSheet = "Active", Optional ToSheet = "Active", Optional FromWB = "This", Optional ToWB = "This"

Views 2
Downloads 0

VBA-Excel Components
ANmarAmdeen
968
Attachments
Revisions

v1.0

Thursday
August
10
2023