In my sheet i have specific cells that need to be selected. I have other vba formulas that copy specific things into these cells based off other information. I have it set up to do these operations based of the cell that is selected. So in my vba i have my code based off the rc format not just a specific cell. This is because i want to use the same macro and on different colums but want it applied to the same rows in different colums. The only problem is that i want to be able to just select the specific cells for formating such as background color.
Heres The Jist of what I am doing!
When using the rc format i place my cursor on cell D13 and then use the following vba coding, Range(Activecell(1,1), ActiveCell(8,1)).Select, creates a selection of D13:D20.Then if i wanted to clear that selection i would enter Selection.ClearContents. Then to get to the next selection my formula would be Range(Activecell(12,1), ActiveCell(19,1)).Select and this would give me a selection of D24:D31. Then i could clear those contents using the same formula Selection.ClearContents. Now i understand by using specific cells this would look like Range("D13:D20,D24:D31").Select . Then the following code would be Range("D24").Activate . That gives me two seperate ranges active at the same time. I can then clear the contents of both those selections at once or change the format of those cells. How would i do this using my activecell rc format. Is there a way to activate more than one selection. Thank you for any help, i have tried many things and none of them work.
Heres The Jist of what I am doing!
When using the rc format i place my cursor on cell D13 and then use the following vba coding, Range(Activecell(1,1), ActiveCell(8,1)).Select, creates a selection of D13:D20.Then if i wanted to clear that selection i would enter Selection.ClearContents. Then to get to the next selection my formula would be Range(Activecell(12,1), ActiveCell(19,1)).Select and this would give me a selection of D24:D31. Then i could clear those contents using the same formula Selection.ClearContents. Now i understand by using specific cells this would look like Range("D13:D20,D24:D31").Select . Then the following code would be Range("D24").Activate . That gives me two seperate ranges active at the same time. I can then clear the contents of both those selections at once or change the format of those cells. How would i do this using my activecell rc format. Is there a way to activate more than one selection. Thank you for any help, i have tried many things and none of them work.