VBA code to copy paste filtered data with multiple columns

[ayman helmy]

Hello all
I need a vba code to do below

I have some filtered data and i can't copy and paste them as 123 to avoid the equations when the filter apply

I need code of vba to do this without unfiltered
Noting the range of the data from column Z3 until column BI passing to all values

 

[dermie_72]

Do you have a sample of the data you are using and what the expected results should be? Where is it being copied to?
Have you tried recording a macro and adjusting it to suit your needs?

 

[ayman helmy]

Do you have a sample of the data you are using and what the expected results should be? Where is it being copied to?
Have you tried recording a macro and adjusting it to suit your needs?

As attached photo there's a data in column Z and AA and AB with equations
I need copy and paste them is same place as 123
And the code include also all columns from column Z until BI

 

[ayman helmy]

Photo Uploaded

 

[ayman helmy]

As attached photo there's a data in column Z and AA and AB with equations
I need copy and paste them is same place as 123
And the code include also all columns from column Z until BI

 

[dermie_72]

I'm sorry but your description of what you want to do is not very informative.
Copy and paste them in the same place as 123? What does this mean? You're valuing them in their existing cells, or theres a sheet called 123
you want to copy Columns Z to BI but to where?
Do you only want to run the code when you have activated the filters or do you want the code to consider the column with the filters and what the filters would be?

 

[Akuini]

@ayman helmy

I have some filtered data and i can't copy and paste them as 123 to avoid the equations when the filter apply

Your description confuses me.
Do you mean you want to replace formula (equation?) with its value in a filtered data (in visible cells only)?
This probably helps:
Excel VBA: easy way to paste to visible cells

 

[Kaper]

Just to make sure:

Are we looking for something else than the problem solved here: Edit the code to Multiple Columns ?