Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox question
I have an input box in the beginning of my macro that ask
for a string to be entered into a cell B2. Then copied down. But i'm getting a #NAME? error in the cells. Here is the code i am using. Dim DSName As String DSName = InputBox("Enter todays Portfolio Name") Range("B2").Select ActiveCell.FormulaR1C1 = "=IF(RC[-1]="""","""",DSName)" Any suggestions? Thank You. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox / VBA question ok = print, cancel = exit | Excel Worksheet Functions | |||
Another InputBox question... | Excel Discussion (Misc queries) | |||
inputbox question | Excel Discussion (Misc queries) | |||
Application.Inputbox Question | Excel Programming | |||
InputBox to get user hidden columns question | Excel Programming |