| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pass address(es) as parameters
I have a subroutine (below) that works by itself. I'd like to modify it to
receive address passed as parameters. How do I do that? Private Sub FormatEntry() Dim myRange As Range Set myRange = Worksheets(5).Range("B30:G31") With myRange .Interior.ColorIndex = 20 .Borders(xlEdgeBottom).Weight = xlMedium .Borders(xlEdgeLeft).Weight = xlMedium .Borders(xlEdgeRight).Weight = xlMedium .Borders(xlEdgeTop).Weight = xlMedium End With End Sub -- Thanks! Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to pass on different parameters to VBA Code? | Excel Worksheet Functions | |||
| How do I pass parameters into Excel from a URL? | Excel Programming | |||
| Is there a way to pass parameters to a web query in excel | Excel Programming | |||
| Pass multiple parameters through macros | Excel Programming | |||
Threaded Mode
