VBA copy paste in table

[Philip00]

Hello Guys,

I would like to as your help with the following issue.

I want to select range and paste as value.

I have done it before like this

Range("AA2:AA118").Copy
Range("AA2:AA118").PasteSpecial xlPasteValues

However now this range is in a table.

Can you help me how to do this?

Thanks in advance

Philip

 

[My Aswer Is This]

If this range is inside the Table. What is the problem?

 

[My Aswer Is This]

You can also do it like this:

Sub Selection_Data()
'Modified  7/18/2018  10:18:22 AM  EDT
Range("AA2:AA118").Value = Range("AA2:AA118").Value
End Sub

 

[sunilbsrv2k]

Hello Guys,

I would like to as your help with the following issue.

I want to select range and paste as value.

I have done it before like this

Range("AA2:AA118").Copy
Range("AA2:AA118").PasteSpecial xlPasteValues

However now this range is in a table.

Can you help me how to do this?

Thanks in advance

Philip

Have you tried this on the table. If not try it. This will work.

 

[Philip00]

Have you tried this on the table. If not try it. This will work.

Hi Guys,

Inside the table it works, thanks for the help and thanks for everyone

 

[My Aswer Is This]

Hi Guys,

Inside the table it works, thanks for the help and thanks for everyone

Not sure what we did to help. But glad you now have things the way you want.