Re: $$Excel-Macros$$ Code to enter value in multiple worksheets

http://tutorialway.com/use-named-range-in-excel/ helpful site -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread title

RE: $$Excel-Macros$$ Code to enter value in multiple worksheets

nd not others. I use trial and error a lot. Regards - Dave. > Date: Fri, 27 Aug 2010 11:20:10 -0700 > Subject: Re: $$Excel-Macros$$ Code to enter value in multiple worksheets > From: heislerk...@gmail.com > To: excel-macros@googlegroups.com > > Wow! This works great. The advan

Re: $$Excel-Macros$$ Code to enter value in multiple worksheets

Wow! This works great. The advantage of not always having to specify the sheet when using Named Ranges never occurred to me. As for this line: c As Range I would have expected to see something like 'c As Cell', but I guess in Excel terms a cell is a range (albeit a very small one)? Thanks much.

RE: $$Excel-Macros$$ Code to enter value in multiple worksheets

Hi Kurt, If your named ranges are really called WS1Data, WS2Data, WS3Data, WS4Data, then your code can be reduced to just a few lines. Sub NoData() Dim i As Integer, c As Range ' Cycle thru each Named Range For i = 1 To 4 ' Cycle thru each cell within the Named Range