Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Syntax for relative R1C1 with variables?
In a Sub I have this code: Application.Goto Reference:="myField" Selection.FormulaR1C1 = "=RC[-3]+RC[-1]" Note that myField is a column (in a database area, myField is the field name of the column) so the formula is calulated on all cells in the column, and for each cell...- hannal
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to define a new database area using varible row/column nr
Hi! I’m trying to do a macro that define a new database area from cell A1 to the cell at the r:th row and c:th column. How can I use a reference that takes variables as argument? Like for example, Cells(r, c)? I can select the new area with this code. range(Cells(10, 1), Cells(r, c)).Select...- hannal
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to get rows/cols from Excel-sheet into a VBA-Array without loops?
Hi! My main problem is how to convert a Range object into an Array without using any loops? This is the background: I need to write a user-defined function in VBA for Excel that takes a Range (2 cols and many rows) in an Excel-sheet as an argument and rearrange the rows so that the values in...- hannal
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
