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"
I had seen this on a previous post in...
I am wondering if you could help me with the following?
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...
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...
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...