excel computer course london - excel macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer course london - Excel Macros

excel computer course london - Excel Macros

resolvedResolved · Low Priority · Version Standard

Byung-hoon has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Excel Macros

Hi...

When it comes to any designated cells within Macros, can I assign "Name-Define or Create" rather than the actual number of cells?

RE: Excel Macros

I would say that if you have a range of cells with a name, you can refer to that range by its name in a macro. If you can use it whilst recording the maco, then go ahead. If not then that is your answer.


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.11 secs.