Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically Generated Range using Macro
Hope someone can help me.
I need to dynamically generate a range. The only value I know are the Columns (C to H); the row index is what needs to be dynamic. Example: ## - is the row index which will change from file to file. With Worksheets(ShtName).Range("C##:H##") .Merge across = True .Font.Bold = True .Font.Size = 10 .Font.Italic = False .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter .BorderAround ColorIndex:=1, Weight:=3 .Interior.ColorIndex = 2 .Value = "INSTRUCTIONS" End With If someone can help and needs more information, just drop me an email or reply. Thanks JM.EE01 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying a Selected Range in a Macro | Excel Discussion (Misc queries) | |||
Macro to Highlight Range | Excel Discussion (Misc queries) | |||
Macro to copy, paste in a range and then delete | Excel Discussion (Misc queries) | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) |