Forum

Merge cells dependi...
 
Notifications
Clear all

Merge cells depending on data length

2 Posts
2 Users
0 Reactions
96 Views
(@Anonymous)
Posts: 0
New Member Guest
 

Hi!

 

I have data in cell A1, and I want to merge columns A to H everytime but depending on length of data the number of rows. For example - it can be A1:H5 for some data, A1:H7 for other.

 

Kindly help with the VBA

Thanks!

 
Posted : 22/09/2024 1:03 pm
(@keebellah)
Posts: 373
Reputable Member
 

Hi,

Guessing is not an option. A sample file with some non-private/non-sensitive data will make understanding and picturing your question better. Don't forget to mention the Excel version you're using.

 
Posted : 24/09/2024 2:49 am
Share: