Populate a table Column with a cell value VBA

[ManUBlueJay]

I am looking to pupulate an ebtire table Column with the value from on cell in VBA
I would have thought this should work.
Any help would be appriciated

ActiveSheet.ListObjects("MyTable").ListColumns(1).DataBodyRange = Range(MyCell).value

 

[HighAndWilder]

I am looking to pupulate an ebtire table Column with the value from on cell in VBA
I would have thought this should work.
Any help would be appriciated

ActiveSheet.ListObjects("MyTable").ListColumns(1).DataBodyRange = Range(MyCell).value

It works for me.

What does Range(MyCell) refer to?

 

[Joe4]

How exactly in "MyCell" defined and set?

What you posted would work if "MyCell" is a String value returning a cell address.
If "MyCell" is actually a range object, then you would just use:

ActiveSheet.ListObjects("MyTable").ListColumns(1).DataBodyRange = MyCell.Value

Also, the fact that "value" is lower case concerns me. It should be upper case.
Maybe that is just a typo on your part. If it is not, it means that you probably created a variable, procedure, or function named "value" (a big no-no, you should never used reserved words as the names of variables, procedures, or functions), and that could cause errors.

 

[ManUBlueJay]

MyCell is a named ranged representing 1 cell

 

[Joe4]

Please show us part of the code where you declare and set that variable.

 

[ManUBlueJay]

There is nothing to show. There is a named range in excell called "MyCell"
I have used Range(MyCell) many times successfully

 

[Joe4]

There is nothing to show. There is a named range in excell called "MyCell"
I have used Range(MyCell) many times successfully

Not like that you have.

Range(MyCell)

is looking for a VBA variable named "MyCell"

If you want to reference the literal range named "MyCell", you need to enclose it in double-quotes, i.e.

Range("MyCell")

Rule of thumb: Anything enclosed in double-quotes is treated a literal string. If it is not enclosed in double-quotes, it is looking for a reference to a variable, function, or procedure.
Since you are looking for a range literally named "MyCell", you need to use double-quotes around it.

 

[ManUBlueJay]

That did it. Thanks

 

[Joe4]

You are welcome.

The double-quotes are very important and make all the difference. I went back and edited the previous post to explain why they are needed in a little more detail.