LinkBack URL
About LinkBacks
I want to build an if statment to run a choice of 3 macros.
if the cell with a number in it is in column (F) run macro 'RUN_ALL_MACROS_F', if in column (H) 'RUN_ALL_MACROS_H', if in column (I) 'RUN_ALL_MACROS_I'
Help will be much appreciated
I want to build an if statment to run a choice of 3 macros.
if the cell with a number in it is in column (F) run macro 'RUN_ALL_MACROS_F', if in column (H) 'RUN_ALL_MACROS_H', if in column (I) 'RUN_ALL_MACROS_I'
Help will be much appreciated
Last edited by will.girling; 11-19-2013 at 01:15 PM.
based on it being in row 1 where the number is, I don't really understand exactly what you mean by "the cell with a number in it"
Please Login or Register to view this content.
i have rows 41-147 which each have one piece of data in either columns F, H or I.
I want the macro to look in each row and choose the cell with data in, based on which row the data is in run the relating macro.
?Please Login or Register to view this content.
this doesnt seem to work. i think i need to define the range as F41:I147, and then make the macro work one row at a time to find the cell with data in, depending what column (F, H, or I) and run its macro. then drop to the next row check column, and run relative macro, all the way from row 41 to row 147.
do you know how i would do this?
Last edited by will.girling; 11-19-2013 at 11:40 AM.
Well that is what it does, but there is nothing to say to your run_all_macros_f what row number you are working on - so I would assume that it would do the same thing regardless of what is in each row.
Maybe if you could post an example spreadsheet with the run_all_macros codes and a brief description of what it does?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks