Automatically insert a blank row below each row that has a value in a certain column

After importing a data set into the worksheet entitled "SPACE", I am trying to find the column entitled "Variability Cpu" and then for every cell in that column that has a value in it, I would like to insert a new row beneath that cell. I thought my code made sense, but I get the "Run-time error '424': Object required" error on the line in red below so apparently I'm missing something. I would greatly appreciate a push in the right direction and an explanation of why I'm getting this error (doesn't the object variable shtS refer to the worksheet object "SPACE"? Why is it saying object required?). Here's what I've got so far:

Please Login or Register  to view this content.

Thanks AB33, but your suggested code inserts exactly rwS/2 (which in this case equals 113) blank rows above the first row in the spreadsheet all at once, instead of just one blank row beneath each cell in the "Variability Cpu" column that has a value. Can you help me understand why my code doesn't work? It seems like it should to me, but then again I'm fairly new to VBA.

First,

Please Login or Register  to view this content.

Is not right if the code is unable to find "Variability Cpu"

Please Login or Register  to view this content.

is wrong, you can only do that on the above line which is a range.
If you could attach a sample and desired output, I will adjust the code

I tried to use your code but was having problems with the loop section for rw = 2 to rws. Inside your loop you have a line of code

Please Login or Register  to view this content.

This line of code works if you insert an equals sign between the Value and then combine the IsNothing into one word, but it doesn't properly account for moving the active cell over newly inserted rows.

I made some changes to the code. The two assumptions that I made are some column will have a heading named "Variability Cpu" and you are using column A to determine how
many times to run your loop.

I hope this works for you!

Please Login or Register  to view this content.

Thanks bstier! Your assumptions were correct and your code worked great, I just had to change "ActiveCell.Value = IsNothing" to "ActiveCell.Value = 0", since it treated "IsNothing" as an undefined variable.