|
本帖最后由 忘情的城市 于 2022-1-19 21:47 编辑
求老师帮忙
WPS能运行,EXCEL2007运行报错
WIN7专业版,EXCEL2007 ,检查没问题
奇怪的是下面的代码在WPS运行无问题,在EXCEL2007运行报错,代码如下
Sub B复制x月x日保户数字表到保户数字()
Dim i%, arr, brr()
With Sheets("汇总")
dt = .[f5].Value
End With
dtt = Format(dt, "m月d日")
ReDim arr1(1 To 3, 1 To 1)
Application.DisplayAlerts = False
With Workbooks.Open(ThisWorkbook.Path & "\" & dtt & "保户数字.xlsx")
Sheets("Sheet1").Select '选择表1
Range("A1:Q200").Select '选定要拷贝的范围
Selection.Copy '准备拷贝
End With
Application.DisplayAlerts = True
With ThisWorkbook.Sheets("保户数字a").Select '选择表2
Range("A1:Q200").Select '选择范围
ActiveSheet.Paste '执行拷贝
End With
Worksheets("保户数字a").Range("F:I").EntireColumn.Hidden = True '隐藏指定列
Worksheets("保户数字a").Range("K:O").EntireColumn.Hidden = True
End Sub
这句报错 With ThisWorkbook.Sheets("保户数字a").Select '选择表2
求解决方法
.
|
|