Hello,
I want to delete or insert a row in excel. I wrote macros for both, and I have BP call the macros and pass in arguments. Can anybody tell me why nothing happens when I call these macros? I believe my syntax is correct, and I'm having success passing in arguments from BP to another macro I made, but both delete and insert rows don't do anything when called. BP will step through without any issues - no error messages - but nothing changes in excel.
I'm relatively new to BP and VBA, so there is room for error in my syntax, but I think it should be working. I can have BP call a macro to delete a specific row, i.e. hard-code the row in the VBA sub, but I'd rather be able to pass in my arguments dynamically from BP. By that I mean calling the hard-coded macros from BP works. Those will delete and/or add rows, but something is going wrong or missing when I try to run the dynamic macros -- passing in the row(s).
I know there will be any number of ways to accomplish deleting or inserting a row from BP, but before moving on to those, I'm curious as to what's going awry here. I'd like to be able to consistently script dynamic VBA macros to call from BP, so this is a good example to walk through.
Thanks
I want to delete or insert a row in excel. I wrote macros for both, and I have BP call the macros and pass in arguments. Can anybody tell me why nothing happens when I call these macros? I believe my syntax is correct, and I'm having success passing in arguments from BP to another macro I made, but both delete and insert rows don't do anything when called. BP will step through without any issues - no error messages - but nothing changes in excel.
I'm relatively new to BP and VBA, so there is room for error in my syntax, but I think it should be working. I can have BP call a macro to delete a specific row, i.e. hard-code the row in the VBA sub, but I'd rather be able to pass in my arguments dynamically from BP. By that I mean calling the hard-coded macros from BP works. Those will delete and/or add rows, but something is going wrong or missing when I try to run the dynamic macros -- passing in the row(s).
I know there will be any number of ways to accomplish deleting or inserting a row from BP, but before moving on to those, I'm curious as to what's going awry here. I'd like to be able to consistently script dynamic VBA macros to call from BP, so this is a good example to walk through.
Thanks