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
Bookmarks