Why won't my cell range populate with any value or allow me to select it in one particular workbook?

[ez08mba]

Problem: I'm writing a function and cannot get any cell range to populate with a value, however, I can in other workbooks. I'm also not receiving any type of error like "#VALUE" or others. It simply doesn't populate. All I can figure is the Workbook or maybe its options are causing the issue but I'm not sure why, or how to resolve it. I'm only experiencing this issue with trying to populate the Cell (i.e., Range) but I'm not having any other issues that I'm aware with the cell references... meaning I can retrieve a value from the cell.

What I've tried: I've tried all the basic types of populating the cell range:

• Range("A1").Value = "Test"
• Sheets(1).Range("A1").Value = "Test"
• Cells(1,1).Value = "Test"
• Worksheets(1).Range("A1").Value = "Test"
• ... as well with .Select

All other VBA code seems to work fine (e.g., For loops, With statements, MsgBoxs, setting and referencing objects and ranges, etc.).

The workbook was created with Excel 2016 as well as the other workbooks that this VBA code does work
Windows 10 Pro

Thanks!

 

[Candyman8019]

Is the sheet protected?

 

[ez08mba]

I think I found my answer here: Cannot VBA write data to cells in Excel 2007/2010 within a function

"A user-defined function called by a formula in a worksheet cell cannot change the environment of Microsoft Excel. This means that such a function cannot do any of the following:

• Insert, delete, or format cells on the spreadsheet.
• Change another cell's value. [My highlighting]
• Move, rename, delete, or add sheets to a workbook.
• Change any of the environment options, such as calculation mode or screen views.
• Add names to a workbook.
• Set properties or execute most methods."

 

[ez08mba]

Is the sheet protected?

Hi,
No, it's not protected. I just posted what I think is the answer. Apparently I cannot do this within a UDF (user-defined function), which must be true because outside of the function and within a Sub procedure I could.