column allignmnet

elgringo56 · May 26th, 2002, 11:23 PM

Dumb question time again. I have need to have a column, EC to appear on the left side of the screen. My column widths are such that I cant get that to happen by selecting a cell 1 in any other column. Is there a way under macro control to make this happen. I cant find it in help any where.

Yogi Anand · May 26th, 2002, 11:37 PM

Quote:

On 2002-05-26 17:23, elgringo56 wrote:
Dumb question time again. I have need to have a column, EC to appear on the left side of the screen. My column widths are such that I cant get that to happen by selecting a cell 1 in any other column. Is there a way under macro control to make this happen. I cant find it in help any where.

Hi elgringo:
Try

Application.Goto Reference:="R1C256"
Application.Goto Reference:="R1C133"

Regards!

elgringo56 · May 26th, 2002, 11:50 PM

Yogi, That worked perfect. Now I am maybe going to impose on you a little, if I am, then just tell me and I will go away. Why does that work? I am sure that string is saying something, but I dont see what it is?

elgringo56 · May 26th, 2002, 11:53 PM

Oh, I see the 133, but I dont see the 256.

Yogi Anand · May 27th, 2002, 12:06 AM

Hi elgringo:
You are my cyber-buddy, you are always welcome! I may not be able to help, but you are always welcome my friend.
256 is column IV (to the end of the worksheet) -- then I asked it to take me to cell EC1, column EC being 133.
I hope this will suffice -- let me know if we need to discuss, why do it this way, or how does it work.

Regards!

elgringo56 · May 27th, 2002, 12:24 AM

Thanks much, Yogi, I see it very clearly. Once again you have saved the day for me. LOL. Where in Michigan are you, I grew up in the city of Charlotte in Michigan, but have not been back for 40 years.

Yogi Anand · May 27th, 2002, 12:41 AM

I am in Rochester Hills -- it is a relatively newer city -- going on about 20 years -- it is next to Pontiac, Michigan. When you are in Michigan, give me a buzz. Where about are you in Mexico?

Regards!

elgringo56 · May 27th, 2002, 12:53 AM

I'm in Puerto Vallarta, been here 8 years now. Decided to semi retire from the rat race up there, so I came here and now custom build PC's for the rich gringos that retire here.

dimrod · May 27th, 2002, 01:24 AM

Quote:

On 2002-05-26 17:23, elgringo56 wrote:
Dumb question time again. I have need to have a column, EC to appear on the left side of the screen. My column widths are such that I cant get that to happen by selecting a cell 1 in any other column. Is there a way under macro control to make this happen. I cant find it in help any where.

You can't find it in help any where?

C'mon ElGringo - I don't think you're making much of any effort.

If you search for either "column" or "scroll" (for example), you will easily find "ScrollColumn Property" and the link to the example reads :-

ScrollColumn Property Example
This example moves column three so that it's the leftmost column in the window.

Worksheets("Sheet1").Activate
ActiveWindow.ScrollColumn = 3

Alternatively, search for let's say "Go" or "GoTo" and "Goto Method Example" is easily located and which reads :-

Goto Method Example
This example selects cell A154 on Sheet1 and then scrolls through the worksheet to display the range.

Application.Goto Reference:=Worksheets("Sheet1").Range("A154"), _
scroll:=True

Also, a good practice to develop is to try the macro recorder when you are looking for some code (VBA experts also make use of the recorder a lot).
If you switch the recorder on, select A1 and then scroll so that EC is on the left, you will get this code (which works just as well as the other two methods) :-

Range("A1").Select
ActiveWindow.SmallScroll ToRight:=132

elgringo56 · May 27th, 2002, 01:37 AM

Yes, Dimrod, I agree, it is always easy to find something in help when you know what your looking for. that seems to be the main problem I have with help. Why I would search scroll when I want to dock a column is beyond me. It is like when I was trying to find something about message box. little did I know I had to search for msg not message. someday I may learn how to use this search, which appears to be written for experienced users, and not for novices, but for now, its seems to be a bit beyond me. I did try the macro recorder, which is why i said that my column sizes didn't allow me to go to a cloumn and have it position as I needed it, I could only get to within one colum that way. But, you point is well taken, I do try to find the answer before I ask and often do, but after an hour or so, I find it nice to have this forum to go to to ease the pain, so to speak.

May 27th, 2002, 12:06 AM	#5
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,448	Hi elgringo: You are my cyber-buddy, you are always welcome! I may not be able to help, but you are always welcome my friend. 256 is column IV (to the end of the worksheet) -- then I asked it to take me to cell EC1, column EC being 133. I hope this will suffice -- let me know if we need to discuss, why do it this way, or how does it work. Regards! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 26th, 2002, 11:23 PM	#1
elgringo56 Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Dumb question time again. I have need to have a column, EC to appear on the left side of the screen. My column widths are such that I cant get that to happen by selecting a cell 1 in any other column. Is there a way under macro control to make this happen. I cant find it in help any where.

May 26th, 2002, 11:50 PM	#3
elgringo56 Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Yogi, That worked perfect. Now I am maybe going to impose on you a little, if I am, then just tell me and I will go away. Why does that work? I am sure that string is saying something, but I dont see what it is?

May 26th, 2002, 11:53 PM	#4
elgringo56 Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Oh, I see the 133, but I dont see the 256.

May 27th, 2002, 12:24 AM	#6
elgringo56 Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Thanks much, Yogi, I see it very clearly. Once again you have saved the day for me. LOL. Where in Michigan are you, I grew up in the city of Charlotte in Michigan, but have not been back for 40 years.

May 27th, 2002, 12:41 AM	#7
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,448	I am in Rochester Hills -- it is a relatively newer city -- going on about 20 years -- it is next to Pontiac, Michigan. When you are in Michigan, give me a buzz. Where about are you in Mexico? Regards!

May 27th, 2002, 12:53 AM	#8
elgringo56 Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	I'm in Puerto Vallarta, been here 8 years now. Decided to semi retire from the rat race up there, so I came here and now custom build PC's for the rich gringos that retire here.

May 27th, 2002, 01:37 AM	#10
elgringo56 Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Yes, Dimrod, I agree, it is always easy to find something in help when you know what your looking for. that seems to be the main problem I have with help. Why I would search scroll when I want to dock a column is beyond me. It is like when I was trying to find something about message box. little did I know I had to search for msg not message. someday I may learn how to use this search, which appears to be written for experienced users, and not for novices, but for now, its seems to be a bit beyond me. I did try the macro recorder, which is why i said that my column sizes didn't allow me to go to a cloumn and have it position as I needed it, I could only get to within one colum that way. But, you point is well taken, I do try to find the answer before I ask and often do, but after an hour or so, I find it nice to have this forum to go to to ease the pain, so to speak.