Change Format of a cell when the row is selected

[Ambassador777]

I have a schedule spreadsheet with 8 columns and various rows (1-200). When the scheduler cancels one of the records, I've created a macro to change the font of the selected row to be Bold, Red, and Strikethrough. Now what i'm trying to accomplish is to not apply the Strikethrough format on Column D, and change the value to "N/A"

The problem is that when I add the Selection.Cells lines, the code executed but seems to be in an endless loop and I have to end task. Before I added the last two lines, everything worked well.

Any help to better work this issue is deeply appreciated.

Please Login or Register  to view this content.

[JBeaucaire]

Please Login or Register  to view this content.

[LJMetzger]

Hi Ambassador777,

1. Your 'for loop' is redundant. Your existing code processes the entire range once for each cell in the range.

2. To process a single cell you would need something like:

Please Login or Register  to view this content.

3. Please note that it is poor programming practice to use potential Excel VBA KEYWORDS as variable names, e.g. 'row' and/or 'column' or 'cells'.


4. The following code may explain what you need.

Please Login or Register  to view this content.

Lewis

[Ambassador777]

Works Great! Thanks for the speedy reply.

[Ambassador777]

Good tip Lewis, I'll take that onboard. Thank you.