Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can someone help me with a macro? I tried recording this, but the issue I am
having is that the data changes from sheet to sheet, and would change month to month, so it won't always be the same. I have about 15 sheets in my workbook, all set up with the same columns. I am trying to select all cells with data in them in columns C and D, then will run the rest of my macro I have already built. I just can't figure out what to add to my macro that will select only cells in columns C & D with data in them. What I want it to do, select all cells in columns C & D with data in them, then my macro multiples the data in those cells times -1 to change the debits and credits. I have everything else done but the selection. I will run this macro on each sheet, so if you can help me figure out a way to run the macro, then select the next sheet, run the macro, etc. to the end, that would be great too! Otherwise I'm selecting each sheet, running the macro, then proceeding to the next sheet. Thanks in advance for any help you can give me!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to go to select sheet | Excel Discussion (Misc queries) | |||
Macro won't select columns | Excel Discussion (Misc queries) | |||
select last cell in a dynamic list using a macro | Excel Discussion (Misc queries) | |||
macro sheet select | Excel Discussion (Misc queries) | |||
Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions |