is there a way to reference a cell with a known column but a changing row.

**Castyel** · 07-08-2012, 08:26 AM

is there a way to reference a cell with a known column but a changing row.

ie

For Each i In Range("S47:S50")
If i = 1 Then
For Each cell In Sheets("sheet1").Range(D?,F?,H?,G?)
If IsEmpty(cell.Value) Then 
MsgBox "Mandatory feild not filled in" 
Application.Goto cell

**Cutter** · 07-08-2012, 08:48 AM

Welcome to the forum, Castyel. Notice that I've added code tags to your post. The forum rules require them so please keep that in mind for your future posts. The following is the actual rule:

RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here