ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   make date BOLD (https://www.excelbanter.com/excel-programming/302373-make-date-bold.html)

miker1999[_19_]

make date BOLD
 
Hi,
Quick and easy question, I hope.

I am inserting the date on a worksheet using offset and I would lik
the date to be BOLD. Here is my code:

.Offset(0, 4).Value = Date

Help,
Mike R

--
Message posted from http://www.ExcelForum.com


Robin Hammond[_2_]

make date BOLD
 
Mike,

something like this

with cells(1,1),offset(0.4)
.value = date
.font.bold = true
End with

Robin Hammond
www.enhanceddatasystems.com

"miker1999 " wrote in message
...
Hi,
Quick and easy question, I hope.

I am inserting the date on a worksheet using offset and I would like
the date to be BOLD. Here is my code:

Offset(0, 4).Value = Date

Help,
Mike R.


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 07:14 AM.

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