Post your code so we can see where the problem is.

"Darko" wrote:

Hi,

I am trying to pull data from a ws in the same workbook, everything is ok
untill i try to create a macro that will do this automatically. The poblem is
when I try to pull a name, it gives me the cell reference instead of the
name. Please direct me in any way...