Well, looks like I got stuck doing some invoices at work since our CIO had a hissy fit about some unrecorded expenditures in the IT department. So know I'm getting huge excel spreadsheets. As I was doing these manually, I was thinking to myself and I figured that since all the info that I need is right there, I can just make some macros to automate it. Would save me literally hours a week. So I figured out how to make macros that calculates expenses, but I need to do the following:
I want a macro that will highlight columns A thru E depending on what line I have selected. Is there such a way to do this?
Right now, it will only do it for a specific Row. I want this macro to move with me depending on the row I'm on. The columns will alwasy remain the same, though.
Here is the macro I have now:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/22/2006 by ***
'
' Keyboard Shortcut: Ctrl+q
'
Range("A1:E1").Select
With Selection.Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End Sub
--------------------------------------------------------
The problem with this is that it is only for row 1. I need it to move with me depending on the row I have highlighted. Any help would be great. Thanks in advance.
I want a macro that will highlight columns A thru E depending on what line I have selected. Is there such a way to do this?
Right now, it will only do it for a specific Row. I want this macro to move with me depending on the row I'm on. The columns will alwasy remain the same, though.
Here is the macro I have now:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/22/2006 by ***
'
' Keyboard Shortcut: Ctrl+q
'
Range("A1:E1").Select
With Selection.Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
End Sub
--------------------------------------------------------
The problem with this is that it is only for row 1. I need it to move with me depending on the row I have highlighted. Any help would be great. Thanks in advance.
