Computer FAQs & Tips

The scenario that I came across is, when I am working on a excel file which required to present in multiple page print out, I will need to keep showing every column on each page printed out. Ok, how do I achieve that?

In this post, I will show you how to get around it.

Say you have data similar to the Screenshot below

In printed out on A4 paper size, there will be 2 pages. Page 1 will include Task Item column, Page 2 will not inlcude Task Item column. Now follow steps below to get repeat print column
Read more...

FAQ & Tip MS-Office, MS-Office-Excel, Printing

If you want to automate your find and replace in MS Office Word Document
You could use or modify this Sub to suit your own needs.

Remember it only support upto 512 bytes (512 characters) of text at the time.

Sub FindReplace()
' Find and replace string in document
' Support up to 512 bytes (double size the default)
  With Selection.Find
    .ClearFormatting
    .Text = "old text"
    .Replacement.ClearFormatting
    .Replacement.Text = "new text"
    .Execute Replace:=wdReplaceAll, Forward:=True, Wrap:=wdFindContinue
  End With
End Sub

Programming MS-Office, MS-Office-Word, VB-VBA