Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by tekfangr
-
Greek and VBA
Hello to all, I've built up a program which handles excel files (open, extract, close...). Everything works well when files names -or worksheet names- are written in western characters, but bugs as they contain greek characters. How can i make VBA handle correctly unicode based characters...- tekfangr
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Problem with inserting formula in cell. VBA
Sorry, not only i pasted an erronous, but i also not left any explanation (by the way english is not my native language, so sorry for the mistakes). Please ignore the post, i found my answer... Thanks for your help, both of you!- tekfangr
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Problem with inserting formula in cell. VBA
Hello to all. I can't get to execute this code without an error (1004): Private Sub CommandButton3_Click() Dim j As Variant Dim x As Variant Dim i As Variant x = "=" For i = 1 To Range("p1").Value j = j + "SUM(B" & 28 + i & ")" Next i MsgBox (x) j = x & j Range("q1").Formula = j End Sub...- tekfangr
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
