How to use named ranges in VBA code using "Columns" and a variation on "Range"

I am trying to clean up my code by using named ranges so that it will still work if/when others add columns or rows to the spreadsheet. These should be pretty easy solutions for most of you but I can't seem to find any answers online.

Here are 2 examples of the code I am trying to update:

I was thinking that replacing "A" with "namedRange" would work but I suppose that's not how the Columns application works. How can I modify the code below to work with a named range instead of the fixed column "A"?

Please Login or Register  to view this content.

For the following I would have thought that replacing "AU" with "namedRange" would do the trick as that's how things have worked for me in the past using the Range application. Unfortunately I get an error when I make the change. I'm sure it's something pretty simple but I can't figure it out.

Please Login or Register  to view this content.

I am highlighting the range I want named, then entering the desired name in the excel "Name Box".