| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to select cells with data
I cant seem to find any help for a code to select cells with data in it and pasting them on to a different sheet. For example... I need Sheet1 to autopopulate with data on sheets 2, 3 and 4 by clicking a button. But I only want it to copy the cells that only have data/text in it and then paste it to Sheet 1. Does anyone have an idea on how to go about doing this? I need help really bad... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to select cells with data
First define the range you need to copy: Set sSheet = Worksheets("Sheet1") Set Scell = Range("A1:A5") Then Destination: Set dSheet = Worksheets("Sheet2") Set Dcell = dSheet.Range("A2") Then copy paste: sCell.Copy DCell.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=false Application.CutCopyMode = False -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "lostandcondfused" wrote: I cant seem to find any help for a code to select cells with data in it and pasting them on to a different sheet. For example... I need Sheet1 to autopopulate with data on sheets 2, 3 and 4 by clicking a button. But I only want it to copy the cells that only have data/text in it and then paste it to Sheet 1. Does anyone have an idea on how to go about doing this? I need help really bad... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to select cells with data | Excel Programming | |||
| Select Merged Cells and Unmerge Spread Merge Data To All Cells | Excel Programming | |||
| Select data from cells | Excel Discussion (Misc queries) | |||
| VBA code to select data from table into combobox | Excel Programming | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Hybrid Mode
