[Help me pleaseeee] i have a q
i'm sorry because this is VBA for CAD forum, but i don't know orther forum for excel like here.so i have a problem with VBA for Excel, help me pleaseeee
SetPrintArea1.xls
i have a excel file like above and i want to set printares with vba for sheet1 butcolumn is not change and row can be change and reference sheet2: round(B1/B2,0)
i have use code: "ActiveSheet.PageSetup.PrintArea = .Resize(Sheet2.).Address"
i want to change B1 into round(B1/B2,0)
What do i must to?
页:
[1]