Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello programmers !
Here is my problem : I wouldlike to put some value into a sheet. the destination cells depends on the selection. The selection is always type of Range. But i have to use a conversion to write it down . Dim bereich as range AZelle = CStr(ActiveCell.Address) .. .. .. Worksheets("Protect").Range(AZelle).Value = dteDatum I dontīt like this . Why canīt i use Worksheets("Protect").bereich.Value = dteDatum |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
returning pivottable object from a range object | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |