VBA convert Activecell to number in spreadsheet

Luluwai

New Member
<!--StartFragment-->
[FONT=Verdana, Helvetica, Arial]I have the following line in a VBA macro which is to written into a cell in the workbook as a formulae:

ActiveCell.Offset(0, 1).Formula = "=LEFT((INDIRECT(""B""& ActiveCell.Row +1)),FIND("" "",(INDIRECT(""B""& ActiveCell.Row +1))&"" "")-1)"

How do I turn the ActiveCell.Row component into a number meaningful to a worksheet?[/FONT]​
<!--EndFragment-->
 

Some videos you may like

This Week's Hot Topics

Top