How to Repair Dll Error Code In a Simple Way?: Troubleshoot:Copy/Paste macro Error

Wednesday, February 24, 2016

Troubleshoot:Copy/Paste macro Error

Copy/Paste macro

Hi! Can someone walk me through how to do the following in VBA?

I have a list of data that is 5 columns wide and n rows long.
I want to be able to highlight the data over 5 columns and however many rows I'd like, but not to exceed 35 rows.
Once selected, I want to be able to hit a hotkey and have a macro paste just the values of the selection into a box that is a range of
cells in the same sheet - ("C2:G35").
And then delete the original selection that I pasted.

I don't know how to say this in VBA and I cant yet navigate through the errors I'm getting.
But I think the code should look roughly like:

If selection.rows.count<=35
and selection.columns.count=5
then selection.copy
.range("C2").pastespecial paste:=xlvalues
selection.delete

end sub

Thank you for the help.

Solutions to the Problem Copy/Paste macro

Download SmartPCFixer for Free Now

Please note that C2:G35 contains only 34 rows.
Can the selection be any range of 5 columns and at most 35 rows? Or should it be within columns C:G? If it can be anywhere:

Sub MoveSelection()
    Dim rngSrc As Range
    Dim rngDst As Range
    Set rngSrc = Selection
    If rngSrc.Rows.Count <= 35 And rngSrc.Columns.Count = 5 Then
        Set rngDst = Range("C2").Resize(rngSrc.Rows.Count, 5)
        If Intersect(rngSrc, rngDst) Is Nothing Then
            rngSrc.Copy
            rngDst.PasteSpecial Paste:=xlPasteValues
            rngSrc.ClearContents
        Else
            MsgBox "Source range overlaps destination range!", vbExclamation
        End If
    Else
        MsgBox "Source range doesn't have correct dimensions!", vbExclamation
    End If
End Sub

Make Sure that your Computer Meets the System Requirements

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing:

Microsoft Windows Requirements :