PDA

View Full Version : VBA



Miguel_
05-30-2016, 01:52 AM
Hi, im not too familiar with VBA but I have an issue where I need the Macro to run over 100 rows but if data is only displays in 20 of those 100, the other 80 needs to rmain blank and not give
a "#VALUE!" error or any other error phrases.

I've tried the following code but I dont know what im missing:

For i = 5 To 220
' if there is a skill
If (Worksheets(Location).Cells(i, 1) <> "") Then
' process rows

I dont know if thats the correct code to use or if I'm mising something.

Thanks in advance.

snb
05-30-2016, 02:38 AM
Your sample file is missing.

SamT
05-30-2016, 05:20 AM
Not enough example code to determine the problem

Sandler
05-30-2016, 05:53 AM
Like snb and SamT mentioned your issue is hard to explain without sample sheet

Is there a formula in the column causing an error?

Can your wrap that formula in an iferror statement?

For example Iferror(formula,"ignore")

Then you can filter our the ignore column.