Results 1 to 22 of 22
Thread: Excel
Hybrid View
-
16th July 2009 13:25 #1Registered User
Join Date: Jul:2009
Location:
Posts: 10
Excel
,
, VBA, , .. worksheet. , , .
VBA worksheet - , ? - - worksheet-a - ?

(-)
-
16th July 2009 16:07 #2
-
16th July 2009 16:11 #3Banned
Join Date: Jun:2008
Location:
Posts: 1,880
........
""
-
16th July 2009 21:08 #4
-
17th July 2009 08:45 #5Registered User
Join Date: Jul:2009
Location:
Posts: 10
@mermaid : .
sheet
, (, ) - 3 sheets VBA .
sheet "EGN" "EGN_Prov" "EGN_Date" VBA .
Sheet1 B2 Excel .
sheet "ENG" - , . .
Sheet1 , B2 EGN_Prov() sheet "EGN", , Proverka(A1) .
@OgiDogi : , , . sheet -, :
=IF(LEN(A1)=10;(IF((MOD(MOD(INT(MID(A1;1 ;1))*2+INT(MID(A1;2;1))*4+INT(MID(A1;3;1 ))*8+INT(MID(A1;4;1))*5+INT(MID(A1;5;1)) *10+INT(MID(A1;6;1))*9+INT(MID(A1;7;1))* 7+INT(MID(A1;8;1))*3+INT(MID(A1;9;1))*6; 11);10)=INT(MID(A1;10;1)));" ";" "));" 10 ")
? :
-, Proverka(A1), .
, , , .. 20 1 12, 19 21 32, 21 41 52, 29- , 30 31 , 01.04.1916 13.04.1916 .. , , sheet , .
.. - -
copyright: entium :
http://hardwarebg.com/forum/showpost...97&postcount=2Last edited by amurder; 17th July 2009 at 08:59. Reason:
-
17th July 2009 10:17 #6
Join Date: Jun:2002
Location: 85435
Posts: 4,619
VB . .
X570 Aorus Elite || R5 3600x || NH-D14 || 32GB RAM || GTX1070Ti Ultra Silent || PCE-AC56 || 850 EVO+MP510+HDDs || SSR-650RT all in Dark Base 900 || EV2736W || G29 || Obutto Ozone+Sparco R333
-
17th July 2009 12:01 #7Registered User
Join Date: Jul:2009
Location:
Posts: 10
VBA?
-
17th July 2009 13:07 #8Banned
Join Date: Jun:2008
Location:
Posts: 1,880
...Create a name to represent a formula or a constant
On the Insert menu, point to Name, and then click Define.
In the Names in workbook box, enter the name for the formula.
In the Refers to box, type = (equal sign), followed by the formula or the constant (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.) value.
-
17th July 2009 15:19 #9Registered User
Join Date: Jul:2009
Location:
Posts: 10
1, .
.
- -
=IF(LEN(A1)=10;IF(F19;" ";" ");" 10 ") - - , .
-
17th July 2009 16:19 #10
-
17th July 2009 16:32 #11Registered User
Join Date: Jul:2009
Location:
Posts: 10
-
17th July 2009 17:05 #12
-
17th July 2009 16:42 #13
-
17th July 2009 16:21 #14Registered User
Join Date: Jul:2009
Location:
Posts: 10
"-" ... 
17:30 - online 27-. 27-.
-
17th July 2009 16:25 #15Banned
Join Date: Jun:2008
Location:
Posts: 1,880
?
-
17th July 2009 17:01 #16Registered User
Join Date: Jul:2009
Location:
Posts: 10
@pavelp
, sheet-
-
17th July 2009 17:09 #17
-
17th July 2009 17:13 #18Registered User
Join Date: Jul:2009
Location:
Posts: 10
,

. online 27.07.2009 . , , .
-
17th July 2009 17:15 #19
-
9th August 2009 22:18 #20Registered User
Join Date: Aug:2009
Location: Asenovgrad
Posts: 1
W, Amurder,

, . , Excel
VBA, . , , , ...




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in