am i missing something in code?

[bhandari]

Sub ThirdClass()
Dim Finalrow As Long
i As Double
Finalrow = cells(65536, 1).End(xlUp).Row
For i = 1 To Finalrow
cells(1, 1).Resize(, 5).Font.Bold = True
Next i
End Sub

error=statement invalid outside type block
i want 5th column text=bold

 

[shg]

That declaration requires Dim, just like the line above.

 

[MARK858]

i want 5th column text=bold

and if it is just the 5th column....

Sub ThirdClass()
Dim Finalrow As Long
Finalrow = Cells(Rows.Count, 1).End(xlUp).Row

Range(Cells(1, 5), Cells(Finalrow, 5)).Font.Bold = True

End Sub

What you have in the code you posted is the first 5 columns.

 

[bhandari]

i cant see bold for 5th column

as well as i have similar code
There is a argumrnt error can u please find out

Sub ThirdClassMethod1()
'need to check it's not working
Dim Finalrow As Long
Dim i As Double
Finalrow = cells(65536, 1).End(xlUp).Row
For i = 1 To Finalrow
cells("A" & i & ":E" & i).Bold = True
Next i
End Sub

 

[MARK858]

See post number 3

If you want it for the first 5 columns

Sub ThirdClass()
Dim Finalrow As Long
Finalrow = Cells(Rows.Count, 1).End(xlUp).Row

Range(Cells(1, 1), Cells(Finalrow, 5)).Font.Bold = True

End Sub

 

[bhandari]

Thank you for your Valuable suggistion
cant we try with this code
How it will work?

For i = 1 To Finalrow
cells("A" & i & ":E" & i).Bold = True

For i = 1 To Finalrow
cells(1, 1).Resize(, 5).Font.Bold = True

 

[hiker95]

i want 5th column text=bold

Bhandari,

If I understand you correctly, then see if the following changes will work for you:

Sub ThirdClass_V2()
' hiker95, 10/28/2017, ME1029086
Dim Finalrow As Long
Dim i As Long
Finalrow = Cells(65536, 1).End(xlUp).Row
For i = 1 To Finalrow
  Cells(i, 5).Font.Bold = True
Next i
End Sub

 

[MARK858]

Thank you for your Valuable suggistion
cant we try with this code
How it will work?

For i = 1 To Finalrow
cells("A" & i & ":E" & i).Bold = True

For i = 1 To Finalrow
cells(1, 1).Resize(, 5).Font.Bold = True

Why would you want to loop through the cells which is slower than referring directly to the range?

 

[bhandari]

Thank You @hiker95

can u please check #6
i want to use that code to get the output

 

[bhandari]

@MARK858 i just want to know how it will work
iam getting argument error #6

i understood that i can use your code #5