Macro to select till last cell visible(numbers in cells) (filtered) ignoring formulas

Hi guys,


Does anyone know how to help me with this?


I wanted to select the first visible cell, which is in a filtered worksheet, untill the last visible cell...The catch is that i've successfully did that, copied the visible cells that i wanted using :

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

The big problem is that this data needs to be pasted in another column. And heres the thing, the cells are formulas (=LEFT (AHx,10), which gives me only 10 digits based on another column. And the thing is that using SHIFT+CTRL DOWN, copies the whole column, even those cells with formulas that seem blank (blank cuz they are not linked to any other cell as the ones i want, but still, they have the formula on it)...Remembering that the number of the cells is variable, since the w/sheet will be updated from times in times. (that's why i've inserted =LEFT in all of them)

What I need is to select and copy only till the cells which gives me the 10 digits, leaving the ones with no result and don't copying them.



I don't know if i made myself clear, but i wished someone could help me with this..


Thanks in advance

Diego

I know it sounds hard...But I don't think it is really that hard..Problem is I'm new using VBA