I have a sheet with the folliwing info:  the "///"  represents a new
column
Sheet 1
A///12

I'm puzzled. I had a perfectly working code using
range(range("A1"), range("A1").SpecialCells(xlLastCell)).copy
and
range(range("A1"), range("A1").SpecialCells(xlLastCell)) .AutoFilter

Is it possible to create autofilter on Rows?
I have an excel sheet with over 5000 rows and 40 columns and I need to
use the autofilter option on the rows.  As transpose function will not
work, cannot interchange rows to columns to use the standard autofilter

How does hide/hide work in Excell for e.g. rows ?
When I hide some rows, how can I see where in my sheet hidden rows are ? Is here a marker indicating
hidden rows ?
And can I also unhide row per row, or does "unhide" work for the entire sheet ?

I highlighted one entire worksheet, Formatted all the cells as Text and then
pasted in to this worksheet a set of text and numbers. Then, I highlighted
one entire column where all the values are numbers and then Formatted this
column as Numbers.

Hi folks - a query which will probably seem a little bit too banal,
but you never know.
I work in hospitality, and therefore receive a lot of tips. I want to
pay all of my tips into the bank account of my landlord to allow me to

Hey y'all,
Is the only way to get templates now through Office On Line rather than
a direct download that works on my PC?
I don't want anything to do with Office On Line. I don't want to have

I export Quickbook reports to Excel spreadsheets they are of  various
nnumber of columns and various number of rows. I want to use macros with
variables in the =sum() functions rather than the hard cell address. Is this
possible and if so how do I do it?

I have several large csv files (semi colon separated) with over 256
columns of data that I need to convert to xls files. I can manually
import 256 columns into a worksheet, then block those columns and
import the next 256 into a new worksheet, but as some of the csv files

I have a cell that contains a formula and formatting. I want to copy
the output from the formula and it's formatting. If I do "Paste
Special" I can choose "Value" to paste the value of the copied cell,
but I cannot copy the format, as the choices are radio buttons and so

Is there an excel formula that will take the contents of a cell in numbers
and convert it into words?
Example 1565 to one 'thousand five hundred and sixty five'
M

i'm sure this is a really simple issue...my knowledge of excel is not
comprehensive, it's all self-taught and very specific (i.e. i have a
great deal of knowledge on some stuff and other stuff i've never used).
i have a spreadsheet with five worksheets in it, and it's not letting

I have a large ish workbook and have created an index page to aid
navigation. I have also created additional menu items for users.  One
of which is a link to the Index page.  On testing I opened a new
workbook and the Index link generated an error.  On checking added

Greetings all
I now to I can convert between different base systems using the code
Function baseconv(InputNum, BaseNum)
  Dim quotient, remainder As Single

How can we match/lookup cell value / variable from "A" cloumn with "B" column. The match value come on "C" column otherwise its FALSE
For Example
A         B         C
RB123    RB127     RB127