VBA Creating Name Range after Pasting Data Over Current Named Range

[Magdoulin]

Hi guys, I hope you’re doing well, I need a big favor from you as it’s going to be complicated code here

I need a code to check if named range is there or not by checking the value of cell M3 in sheet Home

If it exists, to go to the sheet where this named range is there and select it

If it doesn’t exist, so, we need to create it by:
- Going to the sheet name displayed in cell M1 in sheet Home
- Checking the next available empty cell in column C and name it with the needed range name displayed in cell M3 in sheet Home

However, the coming is the hard part
- That later on, there’ll be data pasted over number of cells including the one represents the named range and I need the named range to be redefined to include this new area
- It’s expected that the new area will start from the direct next left cell from the named range cell down to the last non-empty cell in column C expanding till the right to Column O

Is it doable?


P.S.
this was originally posted in OzGrid forum as I could attach the sample file there whereas it's not available here, if you need to check it please visit this link:

https://www.ozgrid.com/forum/forum/...e-after-pasting-data-over-current-named-range