Hello,
I am Using Windows 7 and Excel 7, I have a previously created spreadsheet in which cell B2 contains the date AND time. It looks like this: 2015-07-17 12:55. There is no formula in the formula bar, and it is in a "general format" as best I can tell. (I did not create this spreadsheet.) The...
Hi folks, as my name suggests I am fairly new to VBA and the world of macros but am already enjoying it :)
I wanted to develop a macro which will import a table or a part of a table from word files (user to be prompted for the location of the word file) in to a single excel worksheet on to...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim c As Range
If Target.Cells.Count > 1 Then Exit Sub
Set c = Intersect(Range("C14:C28"), Target)
If c Is Nothing Then Exit Sub
Cells(Target.Row, 1).Resize(, 5) = ""
Target = "X"
End Sub
I had seen this on a previous post in...
Hi all,
I am wondering if you could help me with the following?
<tbody>
A
B
C
D
E
1
Name
Start Date
Team
Language
Agent
2
Bob Smith
01/01/2014
Gareth
English
New
3
Jenny Lemon
01/01/2014
Ben
English
Experienced
4
Richard Smith
01/01/2014
Laura
English
Experienced
5
Steve...
Hi. I am not really a coder and this is new to me but I have an extremely large spreadsheet I need to disect into a seperate workbook for each set of data. While browsing on this forum I saw many references for splitting data, but it always split it due to a certain value in a column. My...
Dear all,
I have a question. Please see below image. I have the Item names in D drive folder named Images. Over 27000 Images are in there. I want when I write the image name in cells (B2 to B2000), Images should appear itself in front of them in (A2 to A2000). Please help. All Images are in...
Hello all,
This is probably a very simple challenge that I've run into, but I am a writer, and I am currently trying to create a spreadsheet that tracks how many words that I type daily.
I am currently using Google Docs spreadsheet application online, but have access to Office 2007 on a...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.