View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default VBA formula building

If your sheet is named 4, then it shouldn't be a problem (it worked for me
when I named my sheet "4". However, you also said your formula looked like

=findid(C5;B3)

which shows your sheet is using A1 notation. You need to move to R1C1
notation or it won't work (in my testing). Otherwise you need to change
your function to use A1 notation.

--
Regards,
Tom Ogilvy



"pm" wrote in message ...
Tom napisal:

Unless your sheet is named 4, then there is no way that will work.


i cannot modyfie sheet's name :/

is there any way to resolve this problem?