Excel macro problem help required

  xania 12:55 11 Aug 2015
Locked
Answered

I have a work book listing cases under action. I need to be able to modify and then hide a row when that specific case closes.

I need the macro to do 3 things in the row selected:

  1. In column F in todays date followed by "for billing"
  2. In columns G-I clear all contents
  3. Hide the entire row

Any help would be welcome.

  xania 08:59 13 Aug 2015

I have now sorted out 1. - its the rest that's the problem. The code will presumably relate to a stated column along the same row?

  xania 11:59 23 Oct 2015
Answer

For anyone watching this stream, I have now worked it out for myself. The code reads:

ActiveCell.Formula = Format(Date, "dd/mm/yyyy") & " to billing"
ActiveCell.Offset(, 1).Resize(1, 5).Clear
ActiveCell.EntireRow.Hidden = True

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPad Air (2019) review

Microsoft Paint's not dead

iMac 27in (2019) review

Les bons plans logiciels et services (2019)