How do i set the font for the active sheet.

J

jjyxk845

Board Regular
Joined
Sep 8, 2006
Messages
89
Am i being stupid? :oops:

How do i set the actice sheets font ?

I've tried

Activesheet.font.name="times new roman" to no avail.

Please can some body point me in the right direction!
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Very close, but Font is not a property of the Activesheet, rather of its Cells property (among others).
Use
Code: 
Activesheet.cells.font.name="times new roman"
instead
Denis
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
run macro on open
Replies
2
Views
118
deanop2
D
T
  • Question
Range of Cells to Body of Email (Original Sig Included) Using VBA
Replies
2
Views
948
John_w
J
M
  • Question
How to track choices in a workbook from several drop down lists and reflect the running choices throughout the month
Replies
0
Views
20
mellojeff
M
L
  • Solved
VBA help: how to set dynamic next available row
2
Replies
16
Views
666
Lil Stinker
L
T
  • Question
VBA- Copy & Paste Range into Outlook as a Picture
Replies
1
Views
129
Domenic
D

Forum statistics

Threads
1,215,063
Messages
6,122,935
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top