Y\u00f6ntem 1: Se\u00e7imdeki sat\u0131rlar\u0131 say\u0131n ve say\u0131y\u0131 mesaj kutusunda g\u00f6r\u00fcnt\u00fcleyin<\/strong><\/span><\/p>\n Bu \u00f6zel \u00f6rnek, ge\u00e7erli se\u00e7imdeki sat\u0131r say\u0131s\u0131n\u0131 sayar ve ard\u0131ndan bu say\u0131y\u0131 bir mesaj kutusunda g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n Y\u00f6ntem 2: Se\u00e7imdeki sat\u0131rlar\u0131 say\u0131n ve say\u0131y\u0131 belirli bir h\u00fccrede g\u00f6r\u00fcnt\u00fcleyin<\/strong><\/span><\/p>\n Bu \u00f6zel \u00f6rnek, ge\u00e7erli se\u00e7imdeki sat\u0131r say\u0131s\u0131n\u0131 sayar ve ard\u0131ndan bu say\u0131y\u0131 E1<\/strong> h\u00fccresinde g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler her y\u00f6ntemin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n E-tablomuzda A1:C17<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ti\u011fimizi varsayal\u0131m:<\/span> <\/p>\n Se\u00e7imdeki sat\u0131r say\u0131s\u0131n\u0131 saymak ve sonu\u00e7lar\u0131 bir mesaj kutusunda g\u00f6r\u00fcnt\u00fclemek i\u00e7in a\u015fa\u011f\u0131daki makroyu olu\u015fturabiliriz:<\/span><\/p>\n Bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda a\u015fa\u011f\u0131daki \u00e7\u0131kt\u0131y\u0131 al\u0131yoruz:<\/span> <\/p>\n Mesaj kutusu bize mevcut se\u00e7imde 17<\/strong> sat\u0131r oldu\u011funu s\u00f6yl\u00fcyor.<\/span><\/span><\/p>\n Elektronik tablomuzda A4:D9<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ti\u011fimizi varsayal\u0131m:<\/span> <\/p>\n Se\u00e7imdeki sat\u0131r say\u0131s\u0131n\u0131 saymak ve sonu\u00e7lar\u0131 E1<\/strong> h\u00fccresinde g\u00f6r\u00fcnt\u00fclemek i\u00e7in a\u015fa\u011f\u0131daki makroyu olu\u015fturabiliriz:<\/span><\/p>\n Bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda a\u015fa\u011f\u0131daki \u00e7\u0131kt\u0131y\u0131 al\u0131yoruz:<\/span> <\/p>\n E1<\/strong> h\u00fccresi bize mevcut se\u00e7imde 6<\/strong> sat\u0131r oldu\u011funu s\u00f6yl\u00fcyor.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde VBA’da di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n VBA kullanarak bir tablodaki sat\u0131rlar\u0131 sayma<\/a> VBA’y\u0131 kullanarak bir se\u00e7imdeki sat\u0131r say\u0131s\u0131n\u0131 saymak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz: Y\u00f6ntem 1: Se\u00e7imdeki sat\u0131rlar\u0131 say\u0131n ve say\u0131y\u0131 mesaj kutusunda g\u00f6r\u00fcnt\u00fcleyin SubCountRowsInSelection () MsgBox Selection.Rows.Count End Sub Bu \u00f6zel \u00f6rnek, ge\u00e7erli se\u00e7imdeki sat\u0131r say\u0131s\u0131n\u0131 sayar ve ard\u0131ndan bu say\u0131y\u0131 bir mesaj kutusunda g\u00f6r\u00fcnt\u00fcler. Y\u00f6ntem 2: Se\u00e7imdeki sat\u0131rlar\u0131 say\u0131n ve say\u0131y\u0131 belirli bir h\u00fccrede g\u00f6r\u00fcnt\u00fcleyin SubCountRowsInSelection […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4997","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n SubCountRowsInSelection<\/span> ()\n\nMsgBox Selection.Rows.Count\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n SubCountRowsInSelection<\/span> ()\n\nRange(\"E1\").Value = Selection.Rows.Count\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n \u00d6rnek 1: Se\u00e7imdeki sat\u0131rlar\u0131 say\u0131n ve say\u0131y\u0131 mesaj kutusunda g\u00f6r\u00fcnt\u00fcleyin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes1.png\")
<\/p>\n SubCountRowsInSelection<\/span> ()\n\nMsgBox Selection.Rows.Count\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n![\"VBA](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes2.png\")
<\/p>\n \u00d6rnek 2: Se\u00e7imdeki sat\u0131rlar\u0131 say\u0131n ve say\u0131y\u0131 belirli bir h\u00fccrede g\u00f6r\u00fcnt\u00fcleyin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes3.png\")
<\/p>\n SubCountRowsInSelection<\/span> ()\n\nRange(\"E1\").Value = Selection.Rows.Count\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignes4.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
VBA kullanarak belirli bir metne sahip h\u00fccreleri sayma<\/a>
VBA kullanarak aral\u0131ktaki benzersiz de\u011ferler nas\u0131l say\u0131l\u0131r?<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"