Format Help needed

JohnJay · Mar 11th, 2002, 02:58 PM

Does anyone know if there is a way to spit out all the formatting and formula info for a row? What I would like to do is be able format an entire row on the fly if a user clicks on a row that is not formated.

thanks John

JohnJay · Mar 11th, 2002, 05:09 PM

Help...Oh! Help

Juan Pablo González · Mar 11th, 2002, 05:17 PM

Your post isn't clear for me. Can you be a little more explicit ?

JohnJay · Mar 11th, 2002, 05:23 PM

Sure Juan,

I have a sheet that each row has formulas and formats that are constant. the only exception of course is referencing. I want to copy all the formating to VBA code, so I can make and add-in that will automatically format a header in the first row, and then format the second row with the above formulas and formats. Then I was thinking that after the initialization above, if a user clicks on a row that is not formated, excel would automatically format that row..like the first row...minus any data the user puts in. Is that possible?

thanks John

Juan Pablo González · Mar 11th, 2002, 05:26 PM

Well, one easy way.

Copy one "formatted" row into the new one. Then, delete all values (You can select special constants if you want to keep formulas) and you have a "clean" row.

JohnJay · Mar 11th, 2002, 05:27 PM

Thats the idea I have when I have at least one row like that...How do I copy all that formating to VBA so that a blank sheet can be initialized like that

Juan Pablo González · Mar 11th, 2002, 05:29 PM

That's the part that sucks. You can "record" a macro while you format each cell, but, there's no direct way of taking the formating. Something are just SO easy to do manually in Excel, but, yet, so long to do in VBA...

JohnJay · Mar 11th, 2002, 05:32 PM

Thats what I was trying to avoid...Reformatting all that just to record a macro...LOL Thanks anyway juan. I wish there was a way to save a row as a formated code

Juan Pablo González · Mar 11th, 2002, 05:34 PM

Can't you hide a preformatted row ? and then, you can copy THAT row...

JohnJay · Mar 11th, 2002, 05:38 PM

Sure can, but thats square 2. Back at square 1, we have a blank sheet. The addin will take a blank sheet and format it with a header row and the next row with the formulas and formats I have tested in anotehr workbook. The idea is that when the addin is loaded, if the sheet is clean, format it like above, else do nothing to it.

Thanks

Mar 11th, 2002, 05:17 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Your post isn't clear for me. Can you be a little more explicit ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 11th, 2002, 05:26 PM	#5
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Well, one easy way. Copy one "formatted" row into the new one. Then, delete all values (You can select special constants if you want to keep formulas) and you have a "clean" row. __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 11th, 2002, 05:29 PM	#7
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	That's the part that sucks. You can "record" a macro while you format each cell, but, there's no direct way of taking the formating. Something are just SO easy to do manually in Excel, but, yet, so long to do in VBA... __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 11th, 2002, 05:34 PM	#9
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Can't you hide a preformatted row ? and then, you can copy THAT row... __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Mar 11th, 2002, 02:58 PM	#1
JohnJay New Member Join Date: Mar 2002 Posts: 37	Does anyone know if there is a way to spit out all the formatting and formula info for a row? What I would like to do is be able format an entire row on the fly if a user clicks on a row that is not formated. thanks John

Mar 11th, 2002, 05:09 PM	#2
JohnJay New Member Join Date: Mar 2002 Posts: 37	Help...Oh! Help

Mar 11th, 2002, 05:23 PM	#4
JohnJay New Member Join Date: Mar 2002 Posts: 37	Sure Juan, I have a sheet that each row has formulas and formats that are constant. the only exception of course is referencing. I want to copy all the formating to VBA code, so I can make and add-in that will automatically format a header in the first row, and then format the second row with the above formulas and formats. Then I was thinking that after the initialization above, if a user clicks on a row that is not formated, excel would automatically format that row..like the first row...minus any data the user puts in. Is that possible? thanks John

Mar 11th, 2002, 05:27 PM	#6
JohnJay New Member Join Date: Mar 2002 Posts: 37	Thats the idea I have when I have at least one row like that...How do I copy all that formating to VBA so that a blank sheet can be initialized like that

Mar 11th, 2002, 05:32 PM	#8
JohnJay New Member Join Date: Mar 2002 Posts: 37	Thats what I was trying to avoid...Reformatting all that just to record a macro...LOL Thanks anyway juan. I wish there was a way to save a row as a formated code

Mar 11th, 2002, 05:38 PM	#10
JohnJay New Member Join Date: Mar 2002 Posts: 37	Sure can, but thats square 2. Back at square 1, we have a blank sheet. The addin will take a blank sheet and format it with a header row and the next row with the formulas and formats I have tested in anotehr workbook. The idea is that when the addin is loaded, if the sheet is clean, format it like above, else do nothing to it. Thanks