Thanks in advance for any and all help.
I have been using the following code to paste formulas from one range to
another.
The range is highlighted and than the code shows an input box for a cell
selection.
Most of the time it works beautifully. Other times it gives a type mismatch
on rnge and fails.
I don't understand why one selection works and another doesn't. With or
without Events enabled.
A1 or R1C1 reference. (I primarily use this in one workbook from
Personal.xls). All selections are similar in size and starting cell - just
different rows.
Using in XL 2k & XL 2003
Dim rnge
Set rnge = Nothing
Application.ScreenUpdating = True
On Error Resume Next
Set rnge = Application.InputBox("Select Cell", Type:=8) <<< errors
here
On Error GoTo 0
Application.ScreenUpdating = False
If rnge Is Nothing Then
Exit Sub
<<< Exits here on error
End If
Selection.Copy
rnge.Cells(1).PasteSpecial Paste:=xlPasteFormulas
Again - Thanks...
--
steveB
Remove "AYN" from email to respond
Bookmarks