lets suppose you want to add the values in column b to comments in column a
here is the code
Dim i As Long
Dim x As String
For i = 1 To Range("a1").End(xlDown).Row
x = Cells(i, 2).Value
Cells(i, 1).AddComment x
it will add value of b1 as comment in a1, b2 as comment in a2, b3 as comment in a3 and so on.....
Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...
Please make sure that you have the latest Version Tool Last Updated on 17 Feb, 2012 Version 1.6 English Version For Excel 2007 &...
Adding Marquee in Excel worksheet Step 1 Step 2 Example 1 Continuous scrolling Add below code module1 or any new module Sub r...