Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Being mostly self taught in VBA I tried to combine lines a and b into c,
using line d as an example from recording a macro. compiler did not like line c. How do you know when "combining" lines will work and when it will not? thanks. Cells(x, y).Borders(xlEdgeLeft).LineStyle = xlContinuous '' a Cells(x, y).Borders(xlEdgeLeft).Weight = xlThick '' b Cells(x, y).Borders(xlEdgeLeft) LineStyle:=xlContinuous, Weight:=xlThick '' c ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True '' d -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combined bar/Line graph defaults to bar | Charts and Charting in Excel | |||
scatter and line combined | Charts and Charting in Excel | |||
combined line-column excel chart | Charts and Charting in Excel | |||
combined scatter plot and line data | Excel Discussion (Misc queries) | |||
Combined line/stacked column chart | Charts and Charting in Excel |