|
Cannot make macro relative
Making a macro that formats "blocks" of data. The data I import ha
differernt number of rows in the blocks,colums are the same. The numbe of blocks per sheet will range from 8 to 14.Each block has it's ow header. I format a space under the header of each block. I also appl conditional formating to that block. I've tried recording in relativ and absolute. So now when I import another sheet of data,since the blocks ar different sizes(row wise) they start on different numbered rows tha the original.The formatting won't cross over without huge errors lik creating the space between the header and the data,but in the dat itself. It keeps acting absolute -- Message posted from http://www.ExcelForum.com |
Cannot make macro relative
How do you tell where a block starts.
are all blocks separated by at least on blank row? do blocks not contain any completely blank rows? -- Regards, Tom Ogilvy "light " wrote in message ... Making a macro that formats "blocks" of data. The data I import has differernt number of rows in the blocks,colums are the same. The number of blocks per sheet will range from 8 to 14.Each block has it's own header. I format a space under the header of each block. I also apply conditional formating to that block. I've tried recording in relative and absolute. So now when I import another sheet of data,since the blocks are different sizes(row wise) they start on different numbered rows than the original.The formatting won't cross over without huge errors like creating the space between the header and the data,but in the data itself. It keeps acting absolute. --- Message posted from http://www.ExcelForum.com/ |
Cannot make macro relative
Yes all blocks are seperated by one blank row. You can tell where a ne
block starts because it will be text(heading) and the end of previous block contains numeric data.There are no row spaces in th data -- Message posted from http://www.ExcelForum.com |
Cannot make macro relative
Just bumping this back up.In a couple of hours it went to page 3.Alot o
action here -- Message posted from http://www.ExcelForum.com |
Cannot make macro relative
|
Cannot make macro relative
|
Cannot make macro relative
|
Cannot make macro relative
Can one of you excel brains answer the question. Geez Louize. What doe
it take to get a reply -- Message posted from http://www.ExcelForum.com |
Cannot make macro relative
The STOP Recording dialog screen also has the Relative References. If this box was closed during the recording of a macro you will
no longer have a choice. To get the toolbar back in sync with recording, start the macro recorder, use View|Toolbars and select the "Stop Recording" toolbar. Then stop the recorder. --- HTH, [ref. recordvba.htm ] David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "light " wrote in message ... Can one of you excel brains answer the question. Geez Louize. What does it take to get a reply. --- Message posted from http://www.ExcelForum.com/ |
Cannot make macro relative
If you had stayed with the original thread instead of doing your "bumping up"
you may have received assistance earlier. "Huh??" in your next post didn't do much either. Gord Dibben Excel MVP On Fri, 2 Apr 2004 18:18:27 -0600, light wrote: Can one of you excel brains answer the question. Geez Louize. What does it take to get a reply. --- Message posted from http://www.ExcelForum.com/ |
Cannot make macro relative
David
My problem doesn't have to do with the button that makes macro relative next to the stop button. My problem is when I record i relative mode it doesn't come out that way. It comes out in absolut mode.See my original post for the specifics of my problem. Gord If I didn't bump it up it would have been long gone into th archives,unanswered -- Message posted from http://www.ExcelForum.com |
| All times are GMT +1. The time now is 05:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com