Thread
:
Excel - Polish version - SUBTOTAL
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
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.
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus