danovkos
11-04-2009, 07:23 AM
hi,
pls. is it possible to made code, which will change range of formulas of filtered data to values?
I try to avoid this error when i try to change formulas to values in selected filtered data.
The information cannot be pasted because the copy area and the paste area are not the same size and shape. Try one of the following....
But area is the same but is filtered.
What i mean is.
I have data about 6000 rows and 100 col. I use existing filter (e.g. amount 1000 in col D) and then i select part of filtered data. This area contains formulas. Then want to run code and i to change this selected, filtered formulas to values.
How can i do this?
thx for your help.
pls. is it possible to made code, which will change range of formulas of filtered data to values?
I try to avoid this error when i try to change formulas to values in selected filtered data.
The information cannot be pasted because the copy area and the paste area are not the same size and shape. Try one of the following....
But area is the same but is filtered.
What i mean is.
I have data about 6000 rows and 100 col. I use existing filter (e.g. amount 1000 in col D) and then i select part of filtered data. This area contains formulas. Then want to run code and i to change this selected, filtered formulas to values.
How can i do this?
thx for your help.