Recent content by msarnie

Again - I have a large spreadsheet with one column that has Fund#. The users frequently sort the spreadsheet on a number of different columns. I created a macro that must have the column Fund# in ascending order. So - when I first begin the Macro I re-sort the spreadsheet based on Fund#. The...

Thanks - I ended up doing that - using application.screenupdating. But I didn't want to - but no other way. The thing though is this group of users like seeing the macro in action - they like knowing that the macro is working and it helps them trouble shoot.

By stopping - I'm saying use F9 to put a break in your code. Use F8 to step through your code - have the top right corner on your screen at A232 and have the active cell on I261. Step through your code to capture the activecell address. Stop and change the screen view by hitting page down a...

Can you try your code for me. Have the top right corner on A232 and have your active cell on I261 and run your code - stop it and change the view of the screen - and run the end - let me know if the top right corner is on A232 It doesn't work for me

No - not sure how to describe I have a very large excel spreadsheet - 1000+ rows and 24+ columns I set up a macro to run in column 9 when the user double clicks the row column. So the user could be only seeing a part of the whole spreasheet on his desktop (screen shot). So the top corner...

If I store the starting location in a large spreadsheet and return to that starting location it will bring the location to the top left corner. Is there a way to capture the top left corner? As if I took a snap-shot of the screen they are viewing in excel - do my macro - and return to the...

I have a large excel spreadsheet that the user starts a macro when they double click a cell. The macro jumps around the sheet. Is there an easy way to make sure that the macro ends at the same screen shot it began with. I think the user will be confussed if I don't return to the beginning screen...

The subform list account responsibility based on user id. The problem is that the subform listing needs to be changable for coverage. So, I need to be able to limit the subform to show only those accounts that are assigned to the user id and also allow the user to pick additional accounts for...

I have a form (Frm Trade Tickets) and a subform (Frm Trade Tickets Subform Detail) that has a link child (PTS) and master (User ID) relationship which I set as an event procedure when the form is open Me.Frm_Trade_Tickets_Subform_Detail.LinkChildFields = "PTS"...