Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
aynsley
 
Posts: n/a
Default Naming Cells with Macros

Is it possible to define cells using macros? I've tried creating a macro by
recording myself naming three cells three different things with the relative
reference on. When I try to apply the macro to a row below, it doesn't name
the new cells.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian G
 
Posts: n/a
Default Naming Cells with Macros

Yes, it's possible. The code should be something as follows. The new
name should be in quotes and can't contain spaces.

Range("a1").Name = "nametoset"
Cells(1,1).Name = "nametoset"

aynsley wrote:
Is it possible to define cells using macros? I've tried creating a macro by
recording myself naming three cells three different things with the relative
reference on. When I try to apply the macro to a row below, it doesn't name
the new cells.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming cells... Steve Excel Worksheet Functions 6 January 3rd 06 07:40 PM
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? excelnovice Excel Worksheet Functions 2 September 25th 05 12:38 AM
requires that merged cells must be identically sized? Catt Excel Discussion (Misc queries) 11 July 3rd 05 12:36 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"