activesheet与worksheet()区别是什么啊?1.在做VBA编程.可是关于“ActiveSheet”与“worksheet("XXX")”的区别不是很清楚.请帮忙区分一下二者的区别.2.向指定在“Example001”中添加线段,如何修改下面语句
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/28 07:06:26
![activesheet与worksheet()区别是什么啊?1.在做VBA编程.可是关于“ActiveSheet”与“worksheet(](/uploads/image/z/13951310-14-0.jpg?t=activesheet%E4%B8%8Eworksheet%28%29%E5%8C%BA%E5%88%AB%E6%98%AF%E4%BB%80%E4%B9%88%E5%95%8A%3F1.%E5%9C%A8%E5%81%9AVBA%E7%BC%96%E7%A8%8B.%E5%8F%AF%E6%98%AF%E5%85%B3%E4%BA%8E%E2%80%9CActiveSheet%E2%80%9D%E4%B8%8E%E2%80%9Cworksheet%28%22XXX%22%29%E2%80%9D%E7%9A%84%E5%8C%BA%E5%88%AB%E4%B8%8D%E6%98%AF%E5%BE%88%E6%B8%85%E6%A5%9A.%E8%AF%B7%E5%B8%AE%E5%BF%99%E5%8C%BA%E5%88%86%E4%B8%80%E4%B8%8B%E4%BA%8C%E8%80%85%E7%9A%84%E5%8C%BA%E5%88%AB.2.%E5%90%91%E6%8C%87%E5%AE%9A%E5%9C%A8%E2%80%9CExample001%E2%80%9D%E4%B8%AD%E6%B7%BB%E5%8A%A0%E7%BA%BF%E6%AE%B5%2C%E5%A6%82%E4%BD%95%E4%BF%AE%E6%94%B9%E4%B8%8B%E9%9D%A2%E8%AF%AD%E5%8F%A5)
activesheet与worksheet()区别是什么啊?1.在做VBA编程.可是关于“ActiveSheet”与“worksheet("XXX")”的区别不是很清楚.请帮忙区分一下二者的区别.2.向指定在“Example001”中添加线段,如何修改下面语句
activesheet与worksheet()区别是什么啊?
1.在做VBA编程.可是关于“ActiveSheet”与“worksheet("XXX")”的区别不是很清楚.请帮忙区分一下二者的区别.
2.向指定在“Example001”中添加线段,如何修改下面语句呢?
例子:想在Excel中的“Example001”Sheet添加线段.
通过宏录制了语句如下,如何把ActiveSheet改为worksheet(“Example001”):
ActiveSheet.Shapes.AddLine(98.25,195.75,354#,195.75).Select
Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadTriangle
Selection.ShapeRange.Line.EndArrowheadLength = msoArrowheadLengthMedium
Selection.ShapeRange.Line.EndArrowheadWidth = msoArrowheadWidthMedium
Selection.ShapeRange.Fill.Transparency = 0#
Selection.ShapeRange.Line.Weight = 3#
Selection.ShapeRange.Line.DashStyle = msoLineRoundDot
Selection.ShapeRange.Line.Style = msoLineSingle
Selection.ShapeRange.Line.Transparency = 0#
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.ForeColor.SchemeColor = 10
Selection.ShapeRange.Line.BackColor.RGB = RGB(255,255,255)
Selection.ShapeRange.Line.BeginArrowheadLength = msoArrowheadLengthMedium
Selection.ShapeRange.Line.BeginArrowheadWidth = msoArrowheadWidthMedium
Selection.ShapeRange.Line.BeginArrowheadStyle = msoArrowheadNone
Selection.ShapeRange.Line.EndArrowheadLength = msoArrowheadLengthMedium
Selection.ShapeRange.Line.EndArrowheadWidth = msoArrowheadWidthMedium
Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadTriangle
activesheet与worksheet()区别是什么啊?1.在做VBA编程.可是关于“ActiveSheet”与“worksheet("XXX")”的区别不是很清楚.请帮忙区分一下二者的区别.2.向指定在“Example001”中添加线段,如何修改下面语句
activesheet表示是当前活动的工作表,一般是手工点击了某个工作表标签,则该工作表就成为了活动工作表了,也可以在程序中通过Activate方法使某个工作表成为活动工作表,这个集合只包含一个工作表.比如
sheets(1).Activate或者worksheet("sheet1").Activate等语句,
而worksheet则是工作表的集合,包含了所有的工作表.