Search results for query: *

Thanks GVF Thanks Skip. I think i understand, but will verify

Skip >Data > Create > List... feature Saw this after my posting. Where do I find that? (In Excel, "Data" is not sub-menu'ed by "Create", and in VBA I don’t see "data" at all?

Thanks Loomah Re MsgBox; I took the parenthesis out, but then "cancel" doesn’t cancel the action. It seems that I to evaluate the answer. What do I do?

Thanks Skip. My problem with "CurrentRegion" is that column "C" has a formula that spans "C16:C39", and there are some Footer notes too. So it copies a larger area then is required in the "Central sheet". But if D:F are empty, "C" returns [""]! (And "D" is a reliable column to test for the...

Thanks Did so.

Hi The code below takes data from individual work cards (i.e., sheets("AD") below), and transfers it to a "central" sheet. Although the entire card is copied and pasted [Range("C16:P39")], not all lines are actually populated. The next paste looks for the first blank line in the "central" sheet...

Hi The code below takes data from individual work cards (i.e., sheets("AD") below), and transfers it to a “central” sheet. Although the entire card is copied and pasted [Range("C16:P39")], not all lines are actually populated. The next paste looks for the first blank line in the “central” sheet...

OK. It seems a user sheet I had added, somehow contrived to cause all this. I have deleted the sheet and redid it. All is now fine. For the sake of clarity, here is the only other piece of code that could have somehow affected this (perhaps by not closing properly last time around) Sub...

Tried rebooting twice already.

PHV Runtime error 1004 Unable to set the Visible property of the Worksheet class.

Skip. Copied and pasted your code. Same result. I tried xlsheetHidden, VeryHidden. No result.

I dont know. I found no declaration for it. I assumed that its a VBA shortcut for 'sheet'. Besides. If that would have been the problem, the debugger would have kicked in at any of; For Each sh In Sheets If sh.Name <> "Welcome

>Multiple Tried with and without. No result. >Personal.xls Recorded a simple macro to the Personal file. Its exists in the VBA. Again, no result. Thanks for your efforts Skip. Mark

Hi Skip. I added a statement "Sheets("welcome").Select", to get me there first. Unfortunately the debugger still kicks in a the same spot. I should point out that this code worked well for 2 years! I cant for the life of me think of what would have changed. Mark

Hi all Here is my code Sub HideSheets() For Each sh In Sheets If sh.Name <> "Welcome" Then sh.Visible=xlVeryHidden Next sh Sheets("Welcome").Range("a1").Select End Sub This worked fine for ages. Suddenly there is this debugger kicking in. Can anyone spot why? Mark

Works a treat! Thank you skip. You are a star! I would love to become more proficient in VB. Is there a book you could recommend? I would be bugging less people here. I am in fiscal accounting, and act a financial controller to various companies. I feel that VBA would increase productivity for...

Hi I have a sheet that hides all but the Welcome Sheet on Opening. Then people enter a user name & Password, and it makes their sheet visible. I just now added a sheet called "Inv Usage" (Or sheet6), and i would like to display it ALL the time. So whoever opens the workbook see THEIR sheet...

Thanks GlennUK! That littkle subtlety does the trick. Mark ExPat

Bang on Dragon! Nothing replaces just simple common sense!

Thanks Dragon Only adds a intiger to the date. If i just put in a cell "+6/8" it returns the fraction. I have tried various methods of getting a text string of +6/8 but it returns VALUE#