Microsoft Office Forums - View Single Post - [Solved] Concatenating two ranges in data validation

Thread: [Solved] Concatenating two ranges in data validation

View Single Post

Old

04-19-2025, 07:20 AM

MartinGM

MartinGM is offline

MartinGM uses Windows 11

Windows 11 MartinGM uses Office 2021

MartinGM uses Office 2021

Office 2021

Competent Performer

The original poster

Join Date: May 2023

Location: England

Posts: 101

MartinGM is on a distinguished road

Default

Thanks Pecover. That's very simple, and takes care of the varying size of the concatenated range

I hadn't seen the # suffix before - what does it do ?
Martin

Reply With Quote