Name box *how to edit

M

mike

Hi..currently i have a form that holds data to be copied
to wkshts...cells A7:D20 range is labeled as form_data.
it was easy to change the name to form_data but now i
want my form to extend beyond the current selection. now
i want it to be from A7:D40. how do i edit the name to
include to expanded cell range? i tried to rename it,
delete and rename but it still shows the previous cells
as selected. any help? thanks. mike
 
A

A.W.J. Ales

Mike,

Insert / Name / Define / Click the name / Change the Refers to box

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
G

Guest

THANK YOU THANK YOU..Jeez how easy it is to forget the
simple things. have a great day...
 
A

A.W.J. Ales

Your welcome Mike and thanks (for the great day).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Pause to Select range then Subtotal 0
How to copy cells by collor code 0
Using wild card characters in Find & Replace 6
How to Edit Lists 2
How can I refer to a row 2
Macro Editing 4
Editing cell names 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7

Top