1

Topic: Error with file transfer on other PC

Children prompt as it is possible to rectify an error, in connection with file transfer on other PC

2

Re: Error with file transfer on other PC

Swears on word Date

With Intersect (.Columns ("N:O").Offset (1))
.Replace Date, "=zz1", 2, False, False
.Rows. Hidden = True
End With

3

Re: Error with file transfer on other PC

Lowering that the line, instead of date should be the first argument Replace;
How defined, what swears on Date?

4

Re: Error with file transfer on other PC

Shocker. Pro, at start the macro highlights the yellow

5

Re: Error with file transfer on other PC

Error the strangest.
Try

.Replace CStr (Date), "=zz1", 2, False, False

to begin with
Also put a screenshot with error illumination

6

Re: Error with file transfer on other PC

Shocker. Pro, here

7

Re: Error with file transfer on other PC

And if directly to inscribe

.Replace "8/7/2018", "=zz1", 2, False, False

that is not present problems?

8

Re: Error with file transfer on other PC

Shocker. Pro,

9

Re: Error with file transfer on other PC

In my opinion it is necessary to reinstall office, this any abnormal behavior.

10

Re: Error with file transfer on other PC

Shocker. Pro, yes probably you are right, office , I now tried generally on other , all works,

11

Re: Error with file transfer on other PC

And so, council on the future - your program will not work at change of regional settings or, for example, on English Windows where the date format differs from Russian. To avoid such problems, use explicit formatting of date at line.

12

Re: Error with file transfer on other PC

, and I am not right. In case in a replaced cell date in a date format like works normally

13

Re: Error with file transfer on other PC

Shocker. Pro, in a cell to change a format? Or in the code to specify a format?

14

Re: Error with file transfer on other PC

In the code. But most likely it is not necessary, should work, at Replace on input Variant, instead of String
However, nothing hinders to check up, changing in a control bar regional settings for the USA and restarting an ex-fur-tree.

15

Re: Error with file transfer on other PC

Shocker. Pro, without changes

16

Re: Error with file transfer on other PC

assei wrote:

Shocker. Pro, without changes

faced such problem earlier
The error consists in incorrectly specified
Now I can not find was specific this file, check up is missing in

17

Re: Error with file transfer on other PC

[/quote] check up is missing in  [/quote] is a question or the statement, forgive for mine not experience, it is possible on more in detail, where as what file

18

Re: Error with file transfer on other PC

Shamanus wrote:

check up

Here difficult to suspect a question)))
Open a window Tools-> References

19

Re: Error with file transfer on other PC

Shocker. Pro, this that that is necessary?

20

Re: Error with file transfer on other PC

Aha. At it, probably, the Date, therefore and such error
It was necessary to guess to advise to pass to function determination, well  so understood

21

Re: Error with file transfer on other PC

Shocker. Pro, it to re-register or it is necessary to search for another?

22

Re: Error with file transfer on other PC

I do not know, can simply drag in the specified place

23

Re: Error with file transfer on other PC

Shocker. Pro, all earned, thanks for the help!