hivishy's blog

Advanced Filter
Submitted by hivishy on 9 January, 2010 - 21:49With advanced filter in Excel using menu while trying to find out Unique, the limitation is that the destination range should be on the same sheet as the source. However, using VBA there is no such limitation. Using VBA the source and destination ranges in Advanced filter need not be on the same sheet.
- Add new comment
- 206 reads

Excel VBA Tip - Bypassing Clipboard while copying values or formula in Excel
Submitted by hivishy on 9 January, 2010 - 18:04In VBA, to Copy Values from range A1:A5 to B1 you will generally write
Sheet1.Range("A1:A5").Copy
Sheet1.Range("B1").PasteSpecial xlPasteValues
Another method:
write the following function in the code window
Sub CopyValues(rngSource As Range, rngTarget As Range)
rngTarget.Resize(rngSource.Rows.Count, rngSource.Columns.Count).Value = rngSource.Value
End Sub
- 4 comments
- Read more
- 506 reads

Recent comments
21 hours 20 min ago
23 hours 12 min ago
1 day 21 hours ago
1 day 22 hours ago
5 days 19 hours ago
6 days 8 hours ago
1 week 11 hours ago
1 week 22 hours ago
1 week 22 hours ago
1 week 2 days ago