VBA Encyclopedia

To update on new Automation Techniques using Excel,Ms Access, SQL Server, Power BI and ASP.Net

Thursday, July 28, 2016

VBA code for autofilter on the basis of Color

keywordsmasterfile.Sheets(1).Range("A2:B2").AutoFilter field:=1, Criteria1:=RGB(204, 153, 255), Operator:=xlFilterCellColor
Posted by Somu at 5:37 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Auto filter on color in VBA

Friday, July 15, 2016

How to enable Power Pivot and Power View Report in Excel 2013

Enable Power Pivot and Power View Report in Excel 2013
Posted by Somu at 10:33 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Power BI, Power Pivot
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Pages

  • Home

Tags

  • Active X Control in VBA Code (1)
  • Add Comments in Spreadsheet via VBA Code (1)
  • ADO for MS Access (1)
  • ADODB connection (2)
  • adUseClient (1)
  • aduseServer (1)
  • array (1)
  • array in vba (1)
  • Attendance Calculation via VBA (1)
  • Auto filter on color in VBA (1)
  • Autofilter in VBA (2)
  • Automated V-lookup (1)
  • Basic VBA (1)
  • Bubble Sort (1)
  • Calendar Utility in VBA (1)
  • Chart Event (1)
  • Class Module in VBA (1)
  • Collection in VBA (1)
  • copy range (1)
  • Create Directory in VBA (1)
  • CTE (1)
  • DynamicVBA macro Chart (3)
  • Efficient VBA (1)
  • Excel Access Connectivity (1)
  • Excel Add-In (1)
  • Excel SQL Connectivity (17)
  • Form Control Checkbox (1)
  • Formula in R1C1 format (1)
  • Google Chrome with VBA (1)
  • I/O Utility in VBA (1)
  • Logic Build-up (1)
  • MSXML2.XMLHTTP (4)
  • Multithreading in VBA (1)
  • Outlook automation in VBA (5)
  • Outlook Utility (3)
  • Pivot Unpivot in SQL (1)
  • PivotChart Using VBA (1)
  • Pivottable Using VBA (1)
  • Power BI (1)
  • Power Pivot (1)
  • PPT in VBA (1)
  • range (1)
  • run a VBA Macro (1)
  • Sample VBA code for website login (1)
  • Sorting in VBA (2)
  • Sorting Spreadsheet (1)
  • Sorting Spreadsheet Data (1)
  • SQL2008 (1)
  • trim in vba (1)
  • Unique no. Summation (1)
  • Use Date (1)
  • Using Array formula in VBA (1)
  • ValidadtionList (1)
  • VB Sample Code (1)
  • VBA code for Databar (1)
  • VBA Code for database connectivity (2)
  • VBA Event (1)
  • VBA Event Handling (1)
  • VBA Excel Tips (1)
  • VBA Hyperlink (1)
  • VBA Macro Code (1)
  • VBA macro Find function (1)
  • VBA Pivot Table (2)
  • VBA PivotTable (1)
  • VBA Programming in Access (1)
  • VBA Sample Code (6)
  • VBA SQL (1)
  • VBA Utility (6)
  • VBA Utility Code (2)
  • VBA Utility Code for removing special character (1)
  • VBA Web Query (1)
  • Vlookup code (1)
  • Window API in VBA (1)
  • Worksheetfunction (1)
  • XLM macro (1)

Thursday, July 28, 2016

VBA code for autofilter on the basis of Color

keywordsmasterfile.Sheets(1).Range("A2:B2").AutoFilter field:=1, Criteria1:=RGB(204, 153, 255), Operator:=xlFilterCellColor
Posted by Somu at 5:37 PM No comments:
Labels: Auto filter on color in VBA

Friday, July 15, 2016

How to enable Power Pivot and Power View Report in Excel 2013

Enable Power Pivot and Power View Report in Excel 2013
Posted by Somu at 10:33 PM No comments:
Labels: Power BI, Power Pivot
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Blog archive

  • ►  2017 (3)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
  • ▼  2016 (59)
    • ►  November (13)
    • ►  October (5)
    • ►  September (2)
    • ►  August (3)
    • ▼  July (2)
      • VBA code for autofilter on the basis of Color
      • How to enable Power Pivot and Power View Report in...
    • ►  June (25)
    • ►  May (3)
    • ►  April (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2015 (11)
    • ►  November (2)
    • ►  October (1)
    • ►  September (2)
    • ►  August (1)
    • ►  May (2)
    • ►  April (2)
    • ►  February (1)
  • ►  2014 (36)
    • ►  November (1)
    • ►  August (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (12)
    • ►  February (12)
    • ►  January (7)
  • ►  2013 (54)
    • ►  December (4)
    • ►  November (5)
    • ►  October (8)
    • ►  September (16)
    • ►  August (9)
    • ►  July (5)
    • ►  June (3)
    • ►  May (3)
    • ►  February (1)
  • ►  2012 (41)
    • ►  October (3)
    • ►  September (3)
    • ►  August (2)
    • ►  July (6)
    • ►  June (7)
    • ►  May (1)
    • ►  April (8)
    • ►  March (6)
    • ►  February (4)
    • ►  January (1)
  • ►  2011 (36)
    • ►  November (6)
    • ►  October (5)
    • ►  September (19)
    • ►  August (4)
    • ►  July (1)
    • ►  February (1)

About Me

MyHealth
View my complete profile

Followers

Watermark theme. Powered by Blogger.