Top "Cell" questions

How to use keyboard to drop-down a menu in an excel cell?

I have a drop-down menu created in an excel cell. Everytime I want to enter a value in that cell, …

excel drop-down-menu cell

Using a number in a cell to generate a cell reference

What I want to do might be better achieved with a database, however I have very limited experience with them, …

excel variables reference cell

Excel cell from which a Function is called

How can I get the cell where my VBA Function is called from? In other words, what is the VBA …

excel vba cell

How to use VBA to make a cell in Excel 2007 transparent

I currently have: Range("Z1").Interior.Color = RGB(255, 255, 255) But this wipes out the borders of the cells. Instead I'd just …

excel vba excel-2007 transparency cell

iTextsharp, PdfPCell.VerticalAlignment and PdfPCell.HorizontalAlignment

Im trying to figure out how to get my text inside a PdfPCell to show in the middle. I have …

c# itext cell vertical-alignment

How to get a cell value in JQGrid?

How to get a cell value in JQGrid? If I use the following syntax – var ret = jQuery("#MyGrid").jqGrid('getRowData', …

jquery jqgrid get cell

Fullcalendar: Change the color for specific days

I'm stuck with a project I get at work. I need to change the background color of some days. It's …

jquery fullcalendar cell background-color

JTable : how to get selected cells?

I have a JTable and its TableModel, it works well but what I want to do now is to get …

swing jtable cell selected

excel cell coloring

I am using c# to color particular cells of excel file. I am using: Application excel = new Application(); Workbook wb = …

c# colors cell

Find the first empty cell in the same column/row

I am trying to work out a formula that will give me the row number of the first empty cell …

excel excel-formula match cell