Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another Easy Question
How do I take the value from each cell defined in the range("A4:A40,F4:F40")
and place 1000 before the value and give this new number a name. Example: Number in A4 is 37984 I want to use 100037984 I have tried... Dim F As Range Dim myNum As Variant Dim Num As Long Worksheets("Sheet1").Activate For Each F In Range("A4:A40", "F4:F40") myNum = F.Value Num = myNum & 1000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy question | Excel Discussion (Misc queries) | |||
REALLY easy question | Excel Worksheet Functions | |||
Easy Question | Excel Programming | |||
Easy question | Excel Programming | |||
new user with easy question? not easy for me | New Users to Excel |