prefer

I would like to refer to cells with the Columns function but cannot figure out how to do it. Example: Rather than Columns("A:O").Select I'd prefer to use a variable so I can say Columns("A":lastcolumn") or something like that. Maybe I should be asking how I can use variables with the Columns...

Is there any way to include an image in a posting? I know that I can upload the image to a file-sharing website and enter its URL in the posting. I would prefer that the image appear within the posting when the webpage is rendered, without the reader having to click on the URL.

Is there anyway of creating a Pivot to count the number of occurrences of "-" when the columns and rows match? I know I can do this by INDEX MATCH MATCH (or similar) but would prefer it in a pivot, that way I can get asy access on the data when clicking on the info?

Hello all! I have the macro below that exports certain columns to a file (in this a m3u8 file). Is there a way I could have excel allow me to type in the file name I'd prefer before exporting? Thanks, Kevin Sub ExportToNotepadOVERALL() Sheets("OVERALL_CLIPS").Select...

I copied a range of cells and pasted them into anew WB as links. This works fine on my pc but on my co-workers it does not. Seems the drive is mapped as "X" rather than "Z". I can overcome this on a user by user basis but would prefer a bettter solution. Suggestions? Range("B2").Select...

Hi all, I would like to use a vba code so that to stop run in certain days. e.g.in 60 days from today. I prefer the days in Latin numeric. Therefore that is bit like licence expired. Thank you all in advance

Hi, I'm wanting to run macros on files I use often I know an option is to save them all to Personal.xlsb but I would prefer to have them in a ribbon tab, has anyone done this ? Ideally in a drop-down menu ( similar layout to PageLayout > Colors menu)

Hello all, I am trying to write VBA code that will show or hide subsequent questions based on the answer to a prior question. As an example: "Do you prefer?" "blue" or "red" (in a drop down) If I answer "blue" I see the 2nd row which has the question "Do you prefer?" "dark blue" or "light...

Hi all, I have this which works when "X" is found in one column: If Cells(ActiveCell.Row, "L").Value = "X" Then But what about when X can be found in one of three columns? If Range("R" & ActiveCell.Row & ":T" & ActiveCell.Row).Value = "X" Then That returns an error. Any ideas? I'd prefer...

Hi I have data that I input in to a chart but the output is MBs and id prefer TB due to the large sizes of data. Could anyone help with a formula? Thanks!

hi, Can some canny person provide me with the applicable VBA based on the following criteria?:- when the date in cell B2 is the same as the date in D2 a popup message stating ' end of period, new date required in next input' would also prefer the text to show in bold red & font 16. Many...

I have heard about using sum(sumif) but in the examples, they use the value. I want to use the cells. Can someone please fix this formula for me please...

Hi, I am using "SUMIF($H$777:$H$806,$G810,I$777:I$806)" formula in my worksheet. For blank cells in the input array the function returns "0". I prefer to have the output cells blank instead of "0" values. What modification can I make in my formula? I do not prefer to use VBA. Thanks in advance!

I would appreciate any thoughts regarding a user defined report generator. Would prefer to buy, or get one free. tia Jack

In my current spreadsheet it would really help to have shortcuts within the sheet. For example when I'm at, say, C20 it would be nice to have a quick way of getting to F300. Are there any buttons or something that I can put near C20 that would take me there? I'd prefer to avoid VBA. Thanks!