VBA Help: Superscrip

Visakh

New Member
Joined
Jul 15, 2014
Messages
39
We have a macro which as the below code. The code is suppose to superscript the text which appears after the year. It fails when the month changes. It was working fine when the month was May/June/July. Is there a better code to raplace the existing code?

Sheets("review").Select



Range("B132").Value = "Performance Attribution Analysis - " & strnewdate & " Month End " & strnewdate1 & "(7)"
Range("B132").Characters(Start:=Len(ActiveCell) - 2, Length:=4).Font.Superscript = True
strFilename = "MSIF International " & Format(LastDay, "mmddyyyy")
With ActiveSheet
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
You need to replace Activecell with Range("B132").Value
 

Watch MrExcel Video

Forum statistics

Threads
1,108,619
Messages
5,523,938
Members
409,543
Latest member
LaMaqu1na

This Week's Hot Topics

Top