Thread: skip blanks on GOTO option

Hi,

I assume you're wanting to extract a range of contiguous cell values to another position from a list which contains blank cells.

In which case Filter the list and exclude the blanks, copy the filtered range and then use Paste Special and tick the 'Skip Blanks' option.

Rgds