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...

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...

How do I post my code?

"michaelberrier" wrote:

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...

Copy and paste your code into the group

"Darko" wrote:

How do I post my code?

"michaelberrier" wrote:

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...

Sub Macro22()
'
' Macro22 Macro
' Macro recorded 6/27/2006 by Darko Naumoski
'

'
Sheets("DiscStmt").Select
Range("D12").Select
ActiveCell.FormulaR1C1 = "=Customers!A18"
Range("H16").Select
ActiveCell.FormulaR1C1 = "=Customers!R[2]C[-5]"
Range("H18").Select
ActiveCell.FormulaR1C1 = "=Customers!RC[-3]"
Range("H19").Select
Sheets("Customers").Select
End Sub

I didnt realize you were talking about the macro code.

ActiveCell.FormulaR1C1 = "=Customers!A18" is coming up w/ =Customers!A18
instead of a name of a customer.

Thank you...

"michaelberrier" wrote:

Copy and paste your code into the group

"Darko" wrote:

How do I post my code?

"michaelberrier" wrote:

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...

You've put an = inside the quotes, therefore Excel thinks you're talking
about the statement as text instead of a reference. Get rid of the quotes and
the extra = and that should fix it up.

"Darko" wrote:

Sub Macro22()
'
' Macro22 Macro
' Macro recorded 6/27/2006 by Darko Naumoski
'

'
Sheets("DiscStmt").Select
Range("D12").Select
ActiveCell.FormulaR1C1 = "=Customers!A18"
Range("H16").Select
ActiveCell.FormulaR1C1 = "=Customers!R[2]C[-5]"
Range("H18").Select
ActiveCell.FormulaR1C1 = "=Customers!RC[-3]"
Range("H19").Select
Sheets("Customers").Select
End Sub

I didnt realize you were talking about the macro code.

ActiveCell.FormulaR1C1 = "=Customers!A18" is coming up w/ =Customers!A18
instead of a name of a customer.

Thank you...

"michaelberrier" wrote:

Copy and paste your code into the group

"Darko" wrote:

How do I post my code?

"michaelberrier" wrote:

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...