ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to format cell's borders by using VBSCript? (https://www.excelbanter.com/excel-programming/366519-how-format-cells-borders-using-vbscript.html)

htphuoc

How to format cell's borders by using VBSCript?
 

How can I format each border separately of a cell by using vbscipt
(asp)?
in my case :
+Left: solid
+Top: dot
+Right: solid
+Bottom: dot
I appreciate your help.


--
htphuoc
------------------------------------------------------------------------
htphuoc's Profile: http://www.excelforum.com/member.php...o&userid=36142
View this thread: http://www.excelforum.com/showthread...hreadid=559181


Norman Jones

How to format cell's borders by using VBSCript?
 
Hi htphuoc.

This is an ideal case for use of the macro recorder; turn on the macro
recorder and perform the necessary operations manually.

This will produce code which can be generalised for your purposes.

If you experience problems in adapting the recorder code, post back with
your problematic code.


---
Regards,
Norman


"htphuoc" wrote in
message ...

How can I format each border separately of a cell by using vbscipt
(asp)?
in my case :
+Left: solid
+Top: dot
+Right: solid
+Bottom: dot
I appreciate your help.


--
htphuoc
------------------------------------------------------------------------
htphuoc's Profile:
http://www.excelforum.com/member.php...o&userid=36142
View this thread: http://www.excelforum.com/showthread...hreadid=559181




htphuoc[_2_]

How to format cell's borders by using VBSCript?
 

Thank you very much


--
htphuoc
------------------------------------------------------------------------
htphuoc's Profile: http://www.excelforum.com/member.php...o&userid=36142
View this thread: http://www.excelforum.com/showthread...hreadid=559181



All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com