Hi,
Can help with copying and pasting cells that contain only numbers ignoring the cells with #N/A values?
Or
How to use the LINEST function if the data contains #N/A values?
thnx.
Hi,
Can help with copying and pasting cells that contain only numbers ignoring the cells with #N/A values?
Or
How to use the LINEST function if the data contains #N/A values?
thnx.
Last edited by snoopyngd; 02-08-2011 at 12:02 PM.
Something along these lines will do:
Of course you will need to edit to match your ranges and/or configuration.Option Explicit Sub Copynumbers() Dim icell As Range For Each icell In Range("A1:A5") If IsNumeric(icell) Then icell.Copy Range("B65536").End(xlUp).Offset(1, 0).PasteSpecial xlPasteAll Else End If Next icell Application.CutCopyMode = False End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks