Best Samsung Tablet Recovery Tool: Troubleshoot:create borders using vba

create borders using vba

hi all,

using macro, i want to create borders from col A - col Y, and for rows it depend with last cell in col A.
i.e.
if col A have values till A1300, then it will create borders from A1:Y1300.
if col A have values till A50, then it will create borders from A1:Y50.

hope you get with i want

many thanks

Regards, Rasyha

Anwsers to the Problem create borders using vba

Download SmartPCFixer to Fix It (Free)

If the requirment is for Borderaround; that could be acheived using BorderAround
With Range("A1", Cells(Cells(Rows.Count, "A").End(xlUp).Row, "Y"))
.Borders.LineStyle = xlNone
.BorderAround xlContinuous, xlThin, xlColorIndexAutomatic
End With

Use the System File Checker tool to repair corrupted or missing system files:

Click Start.
Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
Type or copy paste the below command line into it without quotes:
"Sfc /scannow"

Recommended Method to Fix the Problem: create borders using vba:

How to Fix create borders using vba with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.