ExcelBanter - Macro to Highlight Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro to Highlight Range (https://www.excelbanter.com/excel-discussion-misc-queries/83945-macro-highlight-range.html)

LLoraine

Macro to Highlight Range

Does anyone have a macro that asks for a range like A1:J4800 and then
highlights that range?

Bryan Hessey

Macro to Highlight Range

Just type A1:J4800 into the name box and press enter

--

LLoraine Wrote:
Does anyone have a macro that asks for a range like A1:J4800 and then
highlights that range?

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534111

LLoraine

Macro to Highlight Range

Thanks - I didn't know that!!

"Bryan Hessey" wrote:

Just type A1:J4800 into the name box and press enter

--

LLoraine Wrote:
Does anyone have a macro that asks for a range like A1:J4800 and then
highlights that range?

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534111

All times are GMT +1. The time now is 05:43 AM.