Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The subject pretty much says it all, code example as follows.
Should be ultimately simple. But it doesn't work. An "else without if" error appears. Where am I going wrong?? Thanx, - Mike Sub APUcopy() Dim r As Range Set r = Range("a28") If r Is Nothing Then Exit Sub Else Range("I7:I26").Copy Destination:=("i28.i47") End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Range to new Range and keep DATE format?? | Excel Programming | |||
RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
Macro to copy a specified range to a variable range | Excel Programming | |||
Create/copy combo boxes in one range if condition is met in a different range | Excel Programming |