Impossible to add worksheet!

[PNCD]

I am trying to write a VBA function to write an array to a worksheet to help me debug problems.
I have tried all the variants shown after 'Add worksheet and none of them will add a new worksheet to the workbook. I have not even gotten to the part about writing out the array. So simple and so frustrating that there must be a simple answer!
Thank you for your help.

Sub Array2Range(arrx As Variant)
Dim NumRow As Long, NumCol As Long
Dim WriteRange As Range

NumRow = NumElements(arrx, 1)
NumCol = NumElements(arrx, 2)

'Add worksheet
'Set sh = ThisWorkbook.Worksheets.Add
'sh.Name = "MySheet"

'Worksheets.Add(After:=Sheets(Sheets.Count)).Name = "MySheet"

'Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "MySheet"

'Worksheets.Add , Worksheets(Worksheets.Count)
'ActiveSheet.Name = "Array"

'Write array to new worksheet
Set WriteRange = Range(ActiveSheet.Cells(1, 1), ActiveSheet.Cells(NumRow, NumCol))
WriteRange.Value = arrx

End Sub

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[PNCD]

I am trying to write a VBA function to write an array to a worksheet to help me debug problems.
I have tried all the variants shown after 'Add worksheet and none of them will add a new worksheet to the workbook. I have not even gotten to the part about writing out the array. So simple and so frustrating that there must be a simple answer!
Thank you for your help.

Please Login or Register  to view this content.

[romperstomper]

All of those versions should work (if they weren't commented out), unless your workbook is protected. What exactly is happening? Nothing, an error, or what? (If it's an error, what error?)

[PNCD]

Romperstomper (love the screen name)
The workbook and sheet are not protected.
I observe no error indication. Stepping through the function seems normal - the command executes and goes on to the next.
There is nothing to see in Locals.
Is there another diagnostic view that would show why this command fails to perform?
I recorded a macro to add a sheet and name it. Running this from inside the VBA routine, I see that the Properties window changes to Sheet2 but no sheet is added. The subsequent name command terminates, presumably as there is no Sheet2 to rename.

[romperstomper]

If you're using this version:

Please Login or Register  to view this content.

then you ought to be able to view sh in the Locals window (or the Watch window if you set a watch on it). Does this fail in all workbooks or just one?