Search results

Narayan - You are correct. I meant A1, A2, A3 -- three cells in three different rows. It could also be A1, B5, and E99. So, if I select cells A1, A2, and A3, I'd like the macro to automatically activate the rows for those three cells. From there, the code will copy the rows and paste them into...

I'd like to create VBA that will look to see which cells are active and then select all of the rows for those cells. E.g. On Sheet 1 I select cells A1, B1, C1. I'd like the macro to then select rows A, B, and C.

Narayan - Thank you so much for this code. I was able to get the selection to fill in the cell that I clicked. This is WAY cool. Thank you! David

Wow, that is too cool! So, all of that works great. Now I'm wondering if the control source can be whichever cell was selected before I pulled up the userform.

Great! I've been able to create a userform that displays multiple rows and columns of data from Sheet 1. Now I'm wondering how to select one of the rows in the user form and transfer a data element in that row into a cell on Sheet 2. Narayan mentioned the BoundColumn property. I did some...

Narayan - What code do I put into the RowSource property to get the data from, say, columns A:F on Sheet 2?

Thank you, Narayan. I didn't realize that about the listbox. I'll try it out and post my results.

I'd like to do the following: I'm trying to create a tool to assign staff to various roles in an ongoing project. Each staff member has data associated with him/her (e.g. skills, years experience) that need to be taken into account when an assignment is made. Sheet 1 is where I want to enter the...

You both ROCK!! This works perfectly. I take it that leaving out the $ signs makes it all relative referencing. I was able to copy the formula for the first row into the other rows and it kept the reference for each cell as the cell below it. Thank you, thank you, thank you!

Help! I'm creating a template for a calendar, and I want to conditionally format the number cells so that if there's a holiday (e.g. text) in the cell below it, it will turn red. So, for example, I'd like the "1" for New Year's Day to be red because there's text in the cell below it. See the...