Posted to microsoft.public.excel.programming

jimmy[_5_] jimmy[_5_] is offline

external usenet poster

Posts: 37

Change the row number in macro

Hi all,

I have to write a macro to fill grey to some rows depends on the weekday,
the following code works but sometimes there will be some new rows must be
inserted into the table, it is very time consuming to amend the code (row
number). Is that a possible way for improvement? Thanks

Sheets("Sheet1").Range("A10:J64").Select
Selection.Interior.ColorIndex = xlNone

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA write macro change column with 3 number digits to 4 digits the	James C[_2_]	Excel Discussion (Misc queries)	3	January 25th 10 03:12 PM
Macro to change row number within formula	mpot4	Excel Programming	2	September 21st 05 03:55 AM
Macro to change a number to text	Lori F	Excel Programming	4	November 12th 03 04:44 PM
Macro to change a number to text	Jake Marx[_3_]	Excel Programming	1	November 11th 03 04:34 PM
Macro to change a number to text	Lori F.	Excel Programming	0	November 11th 03 04:28 PM

All times are GMT +1. The time now is 08:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us