Excel - Polish version - SUBTOTAL
 

Hi,

I am using Polish version of Excel and I would like to ask you if you
have experienced the same problem in other localized version or in
Polish maybe ?

I need to write into the cell the formula like this:

..Cells(pr - 1, UBound(Tab35, 2) + 3) = "=SUMY.POSREDNIE(9, ") &
..Cells(pr + 2, UBound(Tab35, 2) + 3).Address & ":" & .Cells(pr +
UBound(Tab35, 1), UBound(Tab35, 2) + 3).Address & ")"


SUMY.POSREDNIE means SUBTOTAL in English

After macro is executed I have an error message "#NAZWA?" (#NAME?).
In VBA code I need to use "," after 9 but in sheet I use ";".

The funny thing is that when I click on the cell end hit enter in the
formula everything is OK and it works properly.

Thanks for your help in advance.

Excel - Polish version - SUBTOTAL
 

..Cells(pr - 1, UBound(Tab35, 2) + 3).FormulaLocal = "SUMY.POSREDNIE..."

HTH
--
AP

a écrit dans le message de news:
...
Hi,

I am using Polish version of Excel and I would like to ask you if you
have experienced the same problem in other localized version or in
Polish maybe ?

I need to write into the cell the formula like this:

.Cells(pr - 1, UBound(Tab35, 2) + 3) = "=SUMY.POSREDNIE(9, ") &
.Cells(pr + 2, UBound(Tab35, 2) + 3).Address & ":" & .Cells(pr +
UBound(Tab35, 1), UBound(Tab35, 2) + 3).Address & ")"


SUMY.POSREDNIE means SUBTOTAL in English

After macro is executed I have an error message "#NAZWA?" (#NAME?).
In VBA code I need to use "," after 9 but in sheet I use ";".

The funny thing is that when I click on the cell end hit enter in the
formula everything is OK and it works properly.

Thanks for your help in advance.

Excel - Polish version - SUBTOTAL
 

Use SUBTOTAL, not SUMY.PSREDNE. VBA works in English, but Excel will do the
translation for you.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Hi,

I am using Polish version of Excel and I would like to ask you if you
have experienced the same problem in other localized version or in
Polish maybe ?

I need to write into the cell the formula like this:

.Cells(pr - 1, UBound(Tab35, 2) + 3) = "=SUMY.POSREDNIE(9, ") &
.Cells(pr + 2, UBound(Tab35, 2) + 3).Address & ":" & .Cells(pr +
UBound(Tab35, 1), UBound(Tab35, 2) + 3).Address & ")"


SUMY.POSREDNIE means SUBTOTAL in English

After macro is executed I have an error message "#NAZWA?" (#NAME?).
In VBA code I need to use "," after 9 but in sheet I use ";".

The funny thing is that when I click on the cell end hit enter in the
formula everything is OK and it works properly.

Thanks for your help in advance.