Hi
I'm using this code:
To copy some stuff from one sheet to other and so it makes a hyperlink to it. Everything works fine exept I'm tryn to get the sheet.name in to cell "B2". And it's not working no matter what I do. Can anyone help please?
Please Login or Register to view this content.
Last edited by stojko89; 11-16-2011 at 06:52 AM.
After the table is copyed and the width of the colums is set I just want the B2 cell to have the same name as the sheet name.
And it already says thatand I'm usingPlease Login or Register to view this content.Please Login or Register to view this content.
You have misspelt ColumnWidth so the code errors before setting the value of B2
Please Login or Register to view this content.
LOL ok I didn't see that
But I fixed that and tryed:
andPlease Login or Register to view this content.
andPlease Login or Register to view this content.
Still doesn't workPlease Login or Register to view this content.
You don't want to use an error handler whilst testing code.
You should use Option Explicit
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You need to post an example workbook
royUK
It's and Option Explicit
I just forgot to copy that row
I've attached the workbook I'm working on and this should all happen when you enter the number in colum A. That's the sheet name later.
this worked for me.
Please Login or Register to view this content.
eh? How can it work for you and not for me?
I just tryed it and the cell B2 is still empty
What value did you enter in column A?
What happens if you put a break point in the code and step through line by line?
The Value in column A? I just enterd the next number in the row that was 0005-2011 and it didn't copy the value.
How do I step through line by line? :s
Goto to the code and with the cursor on the line
press F9 and the line should be hilited in red. Go back to the sheet and enter a value in column A. When the code runs it will stop at the red line. You can then press F8 to step through the code line be line.Please Login or Register to view this content.
So I did the F9 thig and entered a value in Column A and it did stop runing at the red line. And when I press F8 it goes down from the On error GoTo row but in color yellow and then it keeps doing this:
I go from the beggining of this code to the end and again to the beggining and the end and so on...nothing realy happens?Please Login or Register to view this content.
Does the code get to the important line where the sheet name is written into range B2?
No
That is a loop so I would expect it to go around abit. In you example file you have +50 worksheets.
You can select the line
and use F9 to insert another break point. F5 will cause the code to run until it encounters the break. Might also be worth adding one at the start of the error trapping incase it fails before reaching it.Please Login or Register to view this content.
Please Login or Register to view this content.
I've tryed the F9 at the If not SheetExists Then point but when I hit F5 it opens up a pop-up window Macros and I should run this Macro? but this Macro is not listed in the pop-up window.
You are working in an event routine rather than a standard code module so you need to fire the event rather than using ALT+F8 to run a macro.
Update a cell on the worksheet, which will fire the event.
When the code pauses you can then use F5 to resume exectution.
Ok so I went through it step by step. And Now the name was shown...I'm going to try it witouth the brake points to see if it will work.
And nope. When I take out the brake points it doesn't work... and the column width stuff doesnt work.
I have no idea then
Ok so here is what I just did.
I removed the:
Because the tabel and the command buttons are copyed as needed the right width and so on and in the right place and the Target.Name now works finePlease Login or Register to view this content.
This is how the code looks like now. And it copys the name and the table like it's sopse tooPlease Login or Register to view this content.
So Andy! If it wasn't for ur brake points I would never have seen that the column widht doesn't work. So U did it man!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks