| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference Between Range("SelectedRange").Value and ActiveCell.Val
Excel/VBA is pretty nice:
Instead of this: Range("A" & CStr(i)).Value you could use: Range("A" & i).Value or cells(i,"A").Value (Yeah, I know you didn't ask.) James Barrass wrote: Tried Range("A" & CStr(i)).Value to dynamically change the range, only worked when i was a constant -- Dave Peterson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Difference Between Range("SelectedRange").Value and ActiveCell
Thanx anyway, Im used to pascal where you have to convert everthing between
types "Dave Peterson" wrote: Excel/VBA is pretty nice: Instead of this: Range("A" & CStr(i)).Value you could use: Range("A" & i).Value or cells(i,"A").Value (Yeah, I know you didn't ask.) James Barrass wrote: Tried Range("A" & CStr(i)).Value to dynamically change the range, only worked when i was a constant -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace(ActiveCell.Formula, "Round(","") not working as expected | Excel Programming | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why? | Excel Programming | |||
| XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select | Excel Programming | |||
Hybrid Mode
