Neviem ako sa pouzivaju makra, tak som to pridal k nejakemu co sa mi zobrazilo cez Alt+F8, tam som dal Po krokoch a vlozil som to makro do daneho suboru VBAProject (vzorova-tabulka.xls) do Harku1. Odstranilo to ten znak len z prvych 5 riadkov vo vsetkych stlpcoch. Ale uz som to vyriesil inac. Prehnal som to cez Open Office a uz je to OK :-) maro > >Sub pridej_odstran_znak() > Range("A1").Select > Selection.CurrentRegion.Select > p_r = Selection.Columns.Count > p_s = Selection.Rows.Count > For r = 1 To p_r > For s = 1 To p_s > b = Cells(r, s) > Cells(r, s) = "'" & b ' Kdyz chci znak na zacatku > Cells(r, s) = b ' Kdyz nechci znak na zacatku > Next s > Next r > Range("A1").Select >End Sub > >-- >cao, > KamilReceived on Wed, 13 Oct 2004 13:18:28 +0200
This archive was generated by hypermail 2.1.8 : 13. 10. 2004, 13:19 CEST