Hi everyone,
Now, i'm having a small problem with excel.
Here i have 2 cells with content as following:
cell1: world
cell2: hello
I want to create a cell2 with content as following
cell 2: hello world
I have used copy and paste functions in VBA but don't have result as i expect
I only received a result as following
cell2: world
Please help me.
Copy problem in excel, please help me.
Hot Topic
- VBA registry interface
- I am unable to move down in excel cells by VB code
- [Excel] How to convert Excel to jpg, gif image?
- Excel Macros - Grab Pictures from the Net
- sending emails from MS Word with variable subject line
- I am searching a VBS scripting example for a free form path item in Adobe Illustrator
- Trying to create a global variable
- querying/updating linked visual foxpro tables with Access 2003/ODBC
- Using FindWindow API to Get Focus and Send keys to a window
- How to dial a modem and pass a .wav file
Microsoft ISV
- Text wraping on edit box of dialogsheet
- One COM Add-in for all versions of Office (2000 and up)?
- vba create and add a macro for excel programmatically
- whats wrong with this code?
- Does Share exist
- Projects, objects & modules
- Disable specific dates in Access Calendar
- MAil merge problem with amounts with spanish regional settings
- vlookup
- Trying to get just the file name
Copy problem in excel, please help me.
kevinj
GaryMcC
Hi
You can work directly with the cells in VBA. If your sheet is "Sheet1" and your cells are A1 and A2 the below code would give the expected result.
Worksheets("Sheet1").Cells(2, 1).Value = Worksheets("Sheet1").Cells(2, 1).Value & " " & Worksheets("Sheet1").Cells(1, 1).Value