Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste copied data to specified sheet based on range - variable iss
I have the following macro that copies data from the 'Daily Team Performance'
sheet and then dependant on the content of cell B4 on that sheet, should copy this data to the respective named sheet on the 'buzz' workbook. The problem is that when I try to run it I get the 'Invalid Qualifier' message he Set rDestination = Destsheet.Range("B4")... Can anyone see what I am doing wrong as the other option is screeds of code for every variation. Sub UpdateData() Dim Destsheet As String Destsheet = Range("Daily Team Performance!B4") Dim rSource As Excel.Range Dim rDestination As Excel.Range Set rSource = ActiveSheet.Range("Daily Team Performance!B4:M103") Set rDestination = Destsheet.Range("B4") rSource.Copy rDestination.Select Selection.PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=False Range("A1").Select Application.CutCopyMode = False valKill: Set rSource = Nothing Set rDestination = Nothing Exit Sub End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Range Based on Cell Content then Copy/Paste to New Sheet,Looping | Excel Programming | |||
Paste cells copied from another sheet | Excel Discussion (Misc queries) | |||
Assign copied range to a variable | Excel Programming | |||
Copy&Paste variable range based on cell value | Excel Programming | |||
Finding a named range based on cell value and copy/paste to same sheet? | Excel Programming |