Search : in
By :

Find last row of data in excel spreadsheet

Last answer on Sep 24, 2009 3:37:08 am BST jess, on Sep 23, 2009 4:28:02 pm BST 
 Report this message to moderators

Hello,
I'm very new to VBA and macros. I have been tryong to find the last row of data in my excel spreadsheet and then make this bold in a macro so that i have the correct formatting month on month.

I have found some code that worked to give me the last row of data, buit i do not know how to then make this bold.

Please help!

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Find last row of data in excel spreadsheet » in :
Comparing columns and returning value Show
Transfer Data/Formulas using drop down list Show
VBA: Finding Hdc in an Excel worksheet or UserForm Show VBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ... for...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Introduction to Spreadsheet Concepts ShowWhat is a Spreadsheet? A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on numbers contained in a table. It is also possible to automate complex calculations by using a...
Ask your question Reply

1

 venkat1926, on Sep 24, 2009 3:37:08 am BST

Do you need a macro?
control+G and click" special"(left bottom) and click "last cell".
(in the middle of right hand column) . last cell is highlighted and that is the last row.

   
Reply to venkat1926
Ask your question Reply
They need your help