Search results

Just noticed that I had deleted the wb object parameters... Even after putting them back in (DIM wb As Workbook and Set wb = ThisWorkbook) it still doesn't work.

Hello All, I am still pretty fresh when it comes to VBA so the answer to this may be simpler than I have made it so far; Sheet3 contains all the ranges that I want to add as Named Ranges. Row 1 contains the range name and everything below is the range i.e. A2:A2000 (All to be the same size...

Can Ron's VBA be used to copy a named range or table from the target closed workbook?

Hello again, I found Ron's site very useful, thanks Luke M. I was able to apply the VBA with some success which was very satisfying. However, I am struggling to get the right code to pick up a table or named range from the target file. I can specify a range in the code but not a named range...

Thanks Luke M. I hope to test this in a few days.

On opening a 2007 Excel workbook, can VBA copy the contents of a table from a closed workbook located elsewhere on the server and paste it over the data in a worksheet in the opened workbook? Being a novice in VBA I can't work out if this question has been answered in another post in a...

Thanks again SirJB7, I have to admit that I do not understand the VBA code that you wrote - yet! Thanks for taking the time to look at it though, much appreciated.

Thank you SirJB7 and Narayank991 for all you assistance. I have just been informed by the workbook users that it now works fine. No logical reason why it works now but didn't work before because I haven't changed anything yet! They are still using the same workbook. I'll blame it on the...

Sorry SirJB7, the password to open the file is; #20N05%15A01! (upper-case with zeros not letter "O") I have already removed the passwords protecting the sheets. Thanks

Below is the link to the doc. Not sure if I should post the password to open it here too? https://docs.google.com/open?id=0B3ihjwO0b6QWODI1MWM4ZGYtZmY1Yy00MzkyLTljMmUtMDQzYTJiNWM1M2Rj The document is slightly more complicated than first described. Users make selections from drop down lists...

Thanks Narayank991, I used that method a few years ago and I thought it seemed to be the only option at the time but the users did not like it at all. Their preference is this column-width-toggle button, which would be fine if Design Mode would turn off. I'm working on a version of the...

hmmm, it's not so easy to strip the sensetive bits out of this workbook without destroying the workings. My description of the workbook has been simplified drastically to ease the explaination of the problem... I will post the link tomorrow when I have checked the stripped down version very...

Got it... will create google doc shortly

Hello SirJB7, .....if only I could find out how to actually do that :)

Thanks Narayank991 but, unfortunately, I don't think so. The data in column D is text wrapped so once selected from the drop down list it fits the cell but the text in the dropdown list is too wide to be read until the column is expanded. The column needs to be the reduced width for the printed...

I have taken my first steps into VBA and and with my first attempt I've come up with a problem. My workbook is sheet and workbook protected (with column formatting allowed) to stop the numerous users destroying my formulas, formatting and print setup when entering data. Users select from a...

Thanks Hui! That almost solved it :) The EVALUATE() function creates its own macro and I have to save the file in macro enabled format. Although this works for me, it will cause security issues for others which I need to avoid if possible :O Are there any other options?

Hello Chandoo :) Your blogs have solved many of my excel challenges over the last few years but I have come up against my first challenge that I can't find an answer to here. How do you convert a formula written as text into a working formula? e.g. I have a report producing hundreds of...