Macro to make 'Refer to' on Name Manager select column until it comes to a blank cell

**mwallace0965** · 02-23-2015, 05:41 AM

Hi,

New to the forum and new to macros on Excel tbh.

What i'm trying to is make macro that will:
Open up the name manager on the formula tab
Select "Initials"
In "refers to" highlight cell a1 down to the last cell with data on "Solicitor" sheet
ok and close

Hopefully an easy one for you all.

I've been trying to record it using ctrl, shift and down to no avail

***Did search forum for similar resolution but couldn't find anything.

**davesexcel** · 02-23-2015, 06:48 AM

Here ya go,

Please Login or Register  to view this content.

**mwallace0965** · 02-23-2015, 07:10 AM

Wonderful.

Thanks very much

Macro to make 'Refer to' on Name Manager select column until it comes to a blank cell

LinkBack

Thread Tools

Rate This Thread

Display

Macro to make 'Refer to' on Name Manager select column until it comes to a blank cell

Re: Macro to make 'Refer to' on Name Manager select column until it comes to a blank cell

Re: Macro to make 'Refer to' on Name Manager select column until it comes to a blank cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel VBA macro to select range separated by blank row and copy to next empty column

[SOLVED] input date column A, increment B, select blank cell in D and input time. in a macro

Select First Cell in First Blank Column

[SOLVED] Select all cells in a column up to a blank cell

I want to select the first blank cell in column A

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions