View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bigburt bigburt is offline
external usenet poster
 
Posts: 2
Default Can i use range-object for .object.value=

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