Help me 1
I want to autofilter a range using vba, which is the right way, after
making it a table or range is enough |
Help me 1
On Thursday, September 13, 2012 9:40:41 PM UTC-7, TIMOTHY wrote:
I want to autofilter a range using vba, which is the right way, after making it a table or range is enough Hi Timothy, Here's one of many ways. Probably need a fair amount of tweaking to suit your exact needs. Option Explicit Sub FillRng() Dim i As String Dim c As Range i = "A Choice" ' i could be an item from a drop down list ' If so then i = range("A1").value (drop down in A1) For Each c In Range("E2:G10") If c.Value = "" Then c.Value = i Next End Sub HTH Regards, Howard |
All times are GMT +1. The time now is 08:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com