Hey guys,
I have two lines (in a sheet) that I am trying to move based on a formula. The wierd thing is I can get the first one to work fine, but when I select the next line it will not work. I have Line 2, and Line 10. Basically the code is:
ActiveSheet.Shapes("Line 2").select
Selection.ShapeRange.Top = 159
ActiveSheet.Shapes("Line 10").select
Selection.ShapeRange.Top = 300For some reason it just moves Line 2 no matter what I do.
Any help is much appreciated.
Re: Selecting Lines In Vb
Works for me.
You "Basically the code is", could you the actual code?
TJ
Re: Selecting Lines In Vb
That code doesn't even work for me. It will move the first line to what the second line is supposed to go, which shows that it keeps it selected instead of switching selection to Line 10. I even tried putting a cell select line in between, but then it just ignored the Line 10 commands. I am purplexed.
I am getting an error: Run-Time error '-2147024809 (80070057)': The Item with the specified name wasn't found.
I tried a on error resume next, but that just skipped the second line code. I even rebuilt from scratch to make sure everything was named properly to no avail.
Re: Selecting Lines In Vb
I'm not being funny but are you sure you've named the lines correctly because it works for me too. EDIT Sorry didn't read you post properly, I see you've checked again.
Re: Selecting Lines In Vb
Here is my test file.
TJ
Re: Selecting Lines In Vb
Well, thanks for all your help. It appears that the worksheet got glitched or something. I have it working now. Thanks!
Re: Selecting Lines In Vb
Brister,
[thread title]*[/thread title]
Don’t have an account yet? Register yourself now and be a part of our community!