-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ssheet
-
M
Dynamic use of union function
I have a routine that asks for non contiguous columns them copies those columns to a new work sheet. The problem I have run into is that the number of columns are not always the same. I have been using a user form that allows selection of cells that allow the column numbers to be passed to the...- Mitchbvi
- Thread
- activesheet.name columns function ssheet union
- Replies: 13
- Forum: Excel Questions
-
J
Add new row data
I am facing problem with folowing code cant add data to new row Private Sub Submit_Click() Dim ssheet As Worksheet Set ssheet = ThisWorkbook.Sheets("S") nr = ssheet.Cells(Rows.Count, 1).End(xlUp).Row + 1 ssheet.Cells(nr, 5) = Me.Tb1 ssheet.Cells(nr, 6) = Me.Tb2 ssheet.Cells(nr, 7) = Me.Tb3...- jadhavabhay
- Thread
- add data row ssheet ssheet.cellsnr
- Replies: 3
- Forum: Excel Questions
-
Userform Date entry issues
Hi Team, I've been using the following code faithfully on many sheets, but now I'm getting a runtime error on the cdate function as I want the "me.tbdate" textbox to format as a proper date dd/mm/yyyy. for some reason without cdate a standard textbox outputs dates as mmddyy by default. How...- RasGhul
- Thread
- cdate date function ssheet ssheet.cellsnr
- Replies: 0
- Forum: Excel Questions
