PDA

View Full Version : Ho to generate a dynamic range using VBA code



bbuk9999
04-20-2016, 06:50 AM
Hi all,
Does anyone know how to generate a dynamic range using VBA code and how to insert data in this dynamic range? . For example generating a dynamic with data in range Range("A1:D10") dynamically using VBA. Thanks anyone helps

Bob Phillips
04-20-2016, 08:26 AM
A1:D10 isn't dynamic! What determines what cells to include?

bbuk9999
04-20-2016, 08:50 AM
Making a dynamic range based on the inserted data that I want.