Fill Series

H

Humayaun

is it possible to skip hidden rows to fill a series of numbers. If it is
possible please tell me how?

Thanks in advance.
 
J

Jacob Skaria

Dear Humayaun

Convert the series to a formula..

1. Enter the formula in the first cell and copy cell.

2. Keeping the 'copy' select the range of cell in the column with hidden
cells. Press F5. From Goto Window click 'Special'. Select 'Visible cells
only'. OK. This will select all the visible cells.

3. Right click>Paste Special>Formulas.

Post back in case you need any help with the formula....

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Insert Multiple Fields without Dialog closing between each... 0
Request Form - Alert Team Member 0
Shape Fill Help 3
Help Fill Series 1
Fill date series in table 2
exclude certain cells from series fill 1
Generate series according to range and increment 5

Top