LinkBack URL
About LinkBacks
I filtered data
now I need to copy formula and paste values to same visible cells
is there is any possible way to paste values to visible cells only
By Code or Any other way ?
I filtered data
now I need to copy formula and paste values to same visible cells
is there is any possible way to paste values to visible cells only
By Code or Any other way ?
Assuming your filtered formulas are in column A:
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
worked if possible pls explain
SpecialCells(12) are cells that are visible.
SpecialCells(-4123) are cells that have formulas.
If a cell has a formula in it, it will have these two properties (the numbers are just an example):
Range("A1").Formula = "=SUM(1,2)"
Range("A1").Value = 3
That range only has a .Value because it has a .Formula "controlling" the value. Setting .Value = .Value is essentially saying that the value is now "in control", and cells with a hardcoded value in them can't have a formula, so it goes away.
If you are satisfied with the solution, please mark this thread SOLVED, and any reputation points (the * in the lower left of the posts) are appreciated.
Last edited by walruseggman; 01-19-2016 at 09:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks