Tags » Excel

Identification of Active Row in Excel

Identify the active row in Excel:

  • Open Excel
  • Select all cells, Press CTRL +A
  • Click on the Conditional Formatting Option and go to New Rules…
48 more words
Excel

Custom Status Bar in Excel

 For having custom status bar in Excel:

  • Open Excel
  • Press ALT + F11
  • Click on the  Option “This Workbook”
  • Type the code below

Private Sub Workbook_Open()
Application.StatusBar = ("www.onevatan.com")
End Sub
  •  Save it in “Macro-Enabled Mode”

Excel

Deep Copy or Clone an ADODB recordset in VBA

Inspired by this post on SO.

Problem description:

I have been searching for a way of duplicating or copying a recordset in VBA. And by that I mean, having the undelying data independent of each other.

244 more words
Vba

Zašto sam postao fan excela

Kada se povede reč o excelu ne mogu da ne budem subjektivan.

Naravno, postoje i drugi programi koje volim i rado koristim.

Ali, ako bih morao da definišem sopstveni odnos prema excelu svakako bi bilo da sam njegov veliki fan! 436 more words

Excel

Kohler Part # PA-SV530-3215 SV530 E3 EXCEL INDUSTRIES

Kohler Part # PA-SV530-3215 SV530 E3 EXCEL INDUSTRIES

Kohler Part # PA-SV530-3215 SV530 E3 EXCEL INDUSTRIES. If you looking for Kohler Part # PA-SV530-3215 SV530 E3 EXCEL INDUSTRIES. 78 more words

Inserting an Excel chart (graph) into Word or PowerPoint

If you need to insert a chart (sometimes called a “graph”) in your Word document, or in your PowerPoint presentation, there is a handy icon on the Insert tab of the ribbon.   408 more words

Excel

Using the power to make a point and excel at penning the written word

There are many ways to climb the corporate ladder.

Some resort to the spoken word though most of us use the fingers to do the talking. 397 more words

People