Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am using Excel 2007. I have a question. I recorded a macro which enters in
A1 the value 1 B1 the value 2 C1 the value 3 the code looks like this. Sub Macro2() +OnAction <= VB_VarUserMemId1VB_VarUserMemId Range& VB_VarUserMemIdB1VB_VarUserMemId '+AxisGroup +OnAction <= VB_VarUserMemId2VB_VarUserMemId Range& VB_VarUserMemIdC1VB_VarUserMemId '+AxisGroup +OnAction <= VB_VarUserMemId3VB_VarUserMemId Range& VB_VarUserMemIdD1VB_VarUserMemId '+AxisGroup End Sub I thought it should be this kind of format--ish ActiveCell.FormulaR1C1 = "1)" Range("B1").Select ActiveCell.FormulaR1C1 = "2" Range("C1").Select what the heck is +OnAction format? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
from date format convert to text format is wrong | Excel Discussion (Misc queries) | |||
csv format is wrong in Denmark | Excel Discussion (Misc queries) | |||
date in wrong format | New Users to Excel | |||
Cell Format - What's wrong? | Excel Worksheet Functions | |||
Date in wrong format | Excel Discussion (Misc queries) |