Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
= CHAR(Row() + 61)
The subject line works on the worksheet, when entered in row 4 it returns an A. What little tweek do I need to make it work in the test code here?
The word "Row" is highlighted along with the error msg. Sub test() Dim i As Long i = Range("G2").Value Range("A3").Resize(i, i).Select For i = 1 To i ActiveCell.Offset(0, i) = i ActiveCell.Offset(i, 0) = CHAR(Row() + 61) 'SUB OR FUNCTION NOT DEFINED Next End Sub I was a bit suprised that Help was useless using: Ascii Char Char() Char(Row) Thanks, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Char(10) or Char(13) in body of email | Excel Programming | |||
FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
CHAR(10) | Excel Worksheet Functions | |||
How to removed the first three char and last char in XLS | Excel Programming |