I have a rather long SQL query to run with several date/time variables in it. The way I've done it in the past is to record a macro, paste the SQL into the query then afterwards turn the dates/times into variables by manually editing the code in the macro, so that next time it is run the SQL...
I'm trying to write a macro that will delete all of the rows above and all of the columns to the left of a selected cell (the cell might be a difeerent one each time the macro is run) - the aim being that that active cell ends up being in the A1 position. Does anybody have any idea how this is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.