Excel help needed please!!?

Answer You do not need macro for this job.Excel provides a build in function CONCATENATEThis is under the Function > TextThis function take argument the different cellsYou can use this to combine the text... Read More »

Top Q&A For: Excel help needed please!!

Excel UserForm Command Button Code needed please?

Private Sub CommandButton1_Click()ActiveSheet.Range("H5").Value = _ActiveSheet.Range("P8").ValueEnd Sub

Excel UserForm TextBox Font to Change Colour, Help Needed Please?

Try:Private Sub TextBox1_Change()If Me.TextBox1.Value >= 0 ThenMe.TextBox1.ForeColor = &HC000&ElseIf Me.TextBox1.Value < 0 ThenMe.TextBox1.ForeColor = &HFF&End IfEnd Sub

How to Split Multi Sheet Workbook Excel Into Single Excel File using Excelsplitter?

Work with hundreds of sheets in one excel file,instead of copying and pasting every sheet in a new file one by one.

Access Denied When Saving From the Excel 2007 Format to Excel 2003?

Converting a file from Excel 2007 to Excel 2003 allows users with older spreadsheet software to view the content of the file. However, if the folder in which the Excel file is contained is set to "... Read More »