Top "Cell" questions

VBA setting the formula for a cell

I'm trying to set the formula for a cell using a (dynamically created) sheet name and a fixed cell address. …

excel vba cell formula

Get value of a merged cell of an excel from its cell address in vba

How to get the value of a merged cell of an excel having range address like "$B$4:$B$11" in vba

excel vba merge cell

Excel Define a range based on a cell value

Is it possible to define a range based on a value given in a cell. So, for example: My selection …

excel range cell

How do I change a single value in a data.frame?

Could anyone explain how to change a single cell in a data.frame to something else. Basically I just want …

r dataframe cell

Excel doesn't update value unless I hit Enter

I have a very annoying problem in one of my worksheets in a workbook. I am using EXCEL 2007. Any cell's …

excel vba excel-formula cell enter

Format HTML table cell so that Excel formats as text?

I am creating an HTML table that will be opened as a spreadsheet in Excel. What HTML tag or CSS …

html excel formatting cell

How to access the real value of a cell using the openpyxl module for python

I am having real trouble with this, since the cell.value function returns the formula used for the cell, and …

python cell openpyxl

how to convert a cell to string in matlab

Suppose I have a cell v = 'v' [576.5818] [3.0286] [576.9270] 'v' [576.5953] [3.1180] [576.8716] 'f' [ 56] [ 58] [ 52] 'f' [ 56] [ 58] [ 52] and I want to convert this to a cell array …

string matlab cell

Google Spreadheets Scripts: check if cell is empty

I want to input a variable in a cell only if the cell is empty. The if statement, however, does …

google-apps-script google-sheets cell spreadsheet

Cellpadding in one html table cell

Is it possible to have cell padding in just one cell versus the whole html table?

html html-table cell