View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tami Tami is offline
external usenet poster
 
Posts: 123
Default copying cell to a range

In my macro, i identify the active cell address, row# and column #
L=activecell.row
in this example assume the active cell address is D20
then i need to copy that cell to AC20:BB:20 and BF20:BZ20
(if i was on D30, I would be copying to AC30:BB:30 and BF30:BZ20, etc)
i'm having trouble writing the range part with the colon.

do i make a string using ampersands? Range=("AC"&L&":BB:"&L).select?
thanks in advance!
tami