Search results for query: *

This should be a simple thing to do, but I can't seem to get it to work. I have a non-modal userform with a button on it. I want to display the userform and keep it displayed while focus is returned to the document so I can edit it and then press the button on the userform to select a...

I am attempting to convert some WordPerfect files to Word. Pretty straight forward except that the WP files have keyboard merge codes in them. When you run a merge, the keyboard merge command pauses the execution of the merge to allow the user to enter data from the keyboard at specific places...

Dale, Thank you so much for your explanation. I was pulling my hair out trying to figure out this problem! At least now I know the cause!

Thanks for all your help on this. I am thinking that it must be my version of Lotus 123. I am using Release 9.7. I tried the round function, and it still has the same problem. In the process of doing that, I noticed something else that is weird - I copied the 4 columns to another part of the...

I just wrote a set of if statements to further check if all the numbers in the first column were indeed identical, and it confirmed that they are definitely equal.

That was what I suspected at first as well, but I looked at the numbers out to the 15 decimal places that Lotus 123 will display, and they were still identical. By the way, as far as I can tell in Excel 2000, you can still only sort with 3 fields. You might be able to sort with more fields...

I have a set of data consisting of 4 columns where the data in the first 3 columns are the same, and the data in the last column starts at 11 and goes up to 35. For example: A B C D 5 4,106.21 1 0 11 6 4,106.21 1 0 12 7...

That worked perfectly. Thanks!

I must be missing something ... I am writing a macro in Excel. I have a selected range that I copied, and I want to paste the column widths of the selected range to a new range. This can be done by going to the Edit - Paste Special menu and selecting column widths. I recorded that action as a...

You guys are great! Both solutions worked perfectly. Thanks!

I am writing an Excel macro, and I want to select a certain cell on a certain worksheet and make it the very first cell displayed on that worksheet (uppermost and leftmost cell). I don't have a problem selecting a paticular cell on a worksheet, but I can't figure out how to make it the first...

Thanks! I think I can make the Window - New Window option work for what I need.

Thanks for the responses, but I need a way to view 2 different worksheets from the same file, not 2 different files. So I guess what I'm hearing is that there isn't a way to do that in Excel?

I am converting Lotus 123 spreadsheets to Excel. In the Lotus 123 spreadsheet there is a macro that splits the window and lets you view two different worksheets at the same time. Is there anything like that in Excel? So far I have only found the normal window split that lets you view 2...

Is there a way to get a list of all macros that are defined in a Lotus 123 spreadsheet? I am converting Lotus 123 spreadsheets to Excel. These are spreadsheets that I am not familiar with and I need a way to make sure that if there are any macros defined in the Lotus spreadsheets that they...