EXCEL QUERY
EXCEL QUERY
(OP)
Deat Friends,
I want to write an application using macros in Excel. But I want to control the no of rows and columns when the worksheet is opened. How it can be achieved using macros
I want to write an application using macros in Excel. But I want to control the no of rows and columns when the worksheet is opened. How it can be achieved using macros
"Knowledge is power"





RE: EXCEL QUERY
Add this to the "ThisWorkbook" Open Event
Worksheets(1).ScrollArea = "a1:f10"
Regards,
Dave