We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub AdjustANumber(ByRef a As Double) a = 42.42 End Sub Sub TestAdjustANumber() Dim a As Double a = 16.1 ' Here the debugger tells me a = 16.1. This is correct. AdjustANumber (a) ' Here the debugger tells me a = 16.1 but I expected a = 42.42 since it was passed by reference to the AdjustAnumber subroutine. MsgBox a ' This MsgBox displays 16.1 which is incorrect End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|VBA - Why copy area and paste area arent the same size error?||3||46|
|count values within multiple bands||7||34|
|VBA - How to copy the data from workbook to workbook masterfile in VBA?||19||42|
|Zip Codes Excel Spreadsheet||4||25|
Join the community of 500,000 technology professionals and ask your questions.