| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I fill in a cell with text in Excel macro (2003)
Hi,
I am running a macro where I copy and paste values from workbook to another. Is it possible to fill in a cell with text without having to copying it from another workbook. Kind regards, Rikin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I fill in a cell with text in Excel macro (2003)
Is it possible to fill in a cell with text without having to copying it
from another workbook. Yes Range("A1").value="Sometext" Mike "Rikin" wrote: Hi, I am running a macro where I copy and paste values from workbook to another. Is it possible to fill in a cell with text without having to copying it from another workbook. Kind regards, Rikin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I fill in a cell with text in Excel macro (2003)
On 15 dic, 16:32, Mike H wrote:
Is it possible to fill in *a cell with text without having to copying it from another workbook. Yes Range("A1").value="Sometext" Mike "Rikin" wrote: Hi, I am running a macro where I copy and paste values from workbook to another. Is it possible to fill in *a cell with text without having to copying it from another workbook. Kind regards, Rikin Hello. One way is: Sub prueba() Sheets("Hoja2").Range("C2").Resize(Sheets("Hoja1") .Range ("A1").CurrentRegion.Rows.Count, Sheets("Hoja1").Range ("A1").CurrentRegion.Columns.Count).Value = Sheets("Hoja1").Range ("A1").CurrentRegion.Value End Sub Regards, Benito Barcelona |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove fill in text from a cell from an unpopulated fill-in cell | Excel Worksheet Functions | |||
| i cannot get coloured text or fill to work excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro to add text to front of data in cell | Excel Programming | |||
| Excel 2003 & cell fill colours | Excel Discussion (Misc queries) | |||
| How prompt Excel user to fill cell with text, i.e., proposal name | Excel Discussion (Misc queries) | |||
Linear Mode
