shorten vba

  1. H

    shorter way of writing things

    G'day all, can i replace Range("c10").Select: ActiveCell = "" with Range("c10").value = "" I think the answer is yes , but I'm not sure
  2. pedie

    I need help in shortening the code as far as possible. Please help! Thanks

    Hi:) Below is my current code. What it does is copy the selection offset, loop and paste in next empty row.....with selection it gives lines...etc... I want the macro to give 1 gap (blank row) before pasting.... and i want the top row on the table to be in blue colour. Please edit the code...

Some videos you may like

This Week's Hot Topics