Tech Support: In a macro how to find empty cells in a column where Data exists in other columns and Autofill with MISC

In a macro how to find empty cells in a column where Data exists in other columns and Autofill with MISC

what is the code to find empty cells in a column if there is say data in that same row for the Date and autofill the word MISC down in column where the Cell is empty?

thanks so much,
bkel

Anwsers to the Problem In a macro how to find empty cells in a column where Data exists in other columns and Autofill with MISC

Download Error Fixer for Free Now

The filter for .SpecialCells(xlCellTypeBlanks) was not included in the last offering.

Dim N As Long, rng As Range
N = Cells(Rows.Count, 1).End(xlUp).Row
Set rng = Range("G6", Cells(N, 7)).SpecialCells(xlCellTypeBlanks)
rng.Value = "Misc"

The above assumes that you have something in each of the cells (a date?) in column A from row 6 down to the extents of your data; e.g.
no blanks.
In my own reply I wasn't sure about this so I compensated with
Intersect(...).

This will also throw an error if there are no blanks to find.
You might want to insert On Error Resume Next in the second line and push the
N assignment down.

Check Windows System Requirements

Microsoft Windows Requirements :

• 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
• 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
• 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing.

Another Safe way to Fix the Problem: In a macro how to find empty cells in a column where Data exists in other columns and Autofill with MISC:

 

 

How to Fix In a macro how to find empty cells in a column where Data exists in other columns and Autofill with MISC with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will perform a scan for your system. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Related: Black hole Gap in Task Bar Windows 8 1 Pro asus drivers Getting Error code 0x80070015 when doing backup in Windows 7 asus mainboard driver download Metro Apps Still Not Lauching After April 8 Windows 8 1 Update asus motherboard drivers Silverlight Updates causing Windows 7 32bit system to hang at desktop asus support Starting in Oct 2012 My computer started shuting down at radom times I sometimes get a error box saying Microsoft Windows is not responding asus com System Restore vs Windows Backup asus drivers Windows Unexpected Shutdowns Need Help asus support Steps to One-Click Download and Update Asus Touchpad Drivers on Your Computer,Icon Deleted Nd Required,Computer After Infected By Fake Antivirus,Resource (web Proxy) Is Online But Isn't Responding To Connection Attempts,Using Drop.down Box In Word,Win 7 X64 32gb SDHC ReadyBoost Issue
Read More: [Solved] Windows 8Pro keep crashing and having to restart ev,How to Resolve - I have a dell v505w printer that will not l,Troubleshooting:blue screen on start up wundows 7 home premium,I need help interpreting Win7 minidump [Solved],Tech Support: Can I import saved email messages on a flash drive previously from Windows Mail into Windows Live Mail after installing, NOT UPGRADING, to Widows 7?,Application Does Not Start in Windows 7,NTLDR is Missing. Press CTR + ALT + DEL to restart?,Apps keep crashing every time I click on the tile, what's wrong?,Why is windows experience index for graphics score is less than gaming graphics score?,MSE keeps detecting and quarantining trojan js/medfos.b, how to remove it permanently?