![]() |
#2
|
||||
|
||||
![]()
Your code has two different variables called bln - one in the sub, one in the function. If you defined bln once at the top of the module (above the sub) then it would exist at the module level and you would have only one bln and therefore could use and reassign it anywhere in the module.
Alternatively, you pass the variable's value back to the sub by changing the commented line in the function to... Code:
strr = True
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ScottyBee | Word VBA | 8 | 03-25-2019 03:24 PM |
Formula returning zero | allex011 | Excel | 2 | 12-03-2018 02:30 AM |
Hard Returning | Phil H | Excel | 2 | 05-15-2018 03:29 AM |
![]() |
kevskisa | Excel | 2 | 07-28-2015 03:19 AM |
Returning Next Record to the top | bordercollie10 | Mail Merge | 0 | 02-26-2009 09:06 AM |