Getting Value from sheet number and named cell

**TimlmiT** · 10-30-2019, 11:42 AM

Gurus,

I have scoured the earth and cannot figure out how to write this line of code.

Basically I want the value from a named cell from a different worksheet number within the same workbook.

Below was my last go at it.

Idx = ActiveWorkbook.Sheets("Sheet7").Range(Row_Numbs).Value

Please help before I go MAD.
TIA.

Tim

**PaulM100** · 10-30-2019, 11:46 AM

Try this:

Idx = ActiveWorkbook.Names("Row_Numbs").RefersToRange.Value

**TimlmiT** · 10-30-2019, 11:50 AM

Bingo!

I can always count on this website for something I cannot figure out!!

Thanks PaulM100

Tim

Getting Value from sheet number and named cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Getting Value from sheet number and named cell

Re: Getting Value from sheet number and named cell

Re: Getting Value from sheet number and named cell

Thread Information

Users Browsing this Thread

Similar Threads

Open file path from cell, paste into new sheet named from another cell and loop

Look in 2D Named Range and return the Row/Column Number of a reference Cell Value

[SOLVED] If cell contains text contained in a named range return the row number

[SOLVED] Find Value in Sheet Named After Cell and Grab Specific Cell Value

Copy Row from 1 sheet to another sheet named matching cell value

Referncing another cell from a named sheet with the sheet name coming from a list of names

[SOLVED] referencing a sheet named in a cell then using data from that sheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions