Thank you سليم ملي for your formula.
Regards
N Williams
On 30-Sep-15 9:22 PM, سليم ملي wrote:
On Saturday, 19 September 2015 15:01:34 UTC+3, N .williams wrote:
Hello
I would like to know if its possible to use a macro or forumula to
replace every "0" with the header cell value an
Hello Paul
Thanks so much for your effort
I received this macro from another member, which does exactly what I want:
(I'm sending students' individual results in a mailmerge via outlook)
Sub repl()
Dim c As Long, rplc As String
rplc = "0"
With ActiveSheet
With .Cells(1, 1).CurrentRegion
absolutely! several ways.
where do you want the output?This macro does what you SAY, but not necessarily
what you WANT:
Option Explicit
Sub List_Student()
Dim msg As String, R As Integer, C As Integer
Dim tMsg As String
msg = "Students:"
For R = 2 To 7
tMsg = ActiveSheet.Ce
