Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Names
I have a long and wide spreadsheet. I need to add names to
each cell in column 93. The names should be the text in the relevant row in colum 2. The columns in the middle are full of other information. I tried the following code. The error message comes up as "That name is not Valid". For Each MyCell In MyRange MyCell.Offset(0, 92).Name = MyCell.Text Next MyCell Any help is appriciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Names
try
For Each MyCell In MyRange MyCell.Offset(0, 92).Name = MyCell.Text Next MyCell For Each MyCell In MyRange MyCell.Offset(0, 92).value = MyCell Next MyCell -- Don Guillett SalesAid Software "Jamal" wrote in message ... I have a long and wide spreadsheet. I need to add names to each cell in column 93. The names should be the text in the relevant row in colum 2. The columns in the middle are full of other information. I tried the following code. The error message comes up as "That name is not Valid". For Each MyCell In MyRange MyCell.Offset(0, 92).Name = MyCell.Text Next MyCell Any help is appriciated. Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Names
Jamal,
Try something like the following: Dim MyCell As Range For Each MyCell In Application.Intersect(ActiveSheet.UsedRange, _ ActiveSheet.Columns(93)) MyCell.Name = MyCell.EntireRow.Cells(1, "B").Text Next MyCell -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jamal" wrote in message ... I have a long and wide spreadsheet. I need to add names to each cell in column 93. The names should be the text in the relevant row in colum 2. The columns in the middle are full of other information. I tried the following code. The error message comes up as "That name is not Valid". For Each MyCell In MyRange MyCell.Offset(0, 92).Name = MyCell.Text Next MyCell Any help is appriciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) |