PDA

View Full Version : Excel Help


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 [108] 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174
  1. Auto-filter turning off in protected worksheet
  2. Find Times Greater than Time Entered
  3. [SLEEPER:] Retrieve Values through an RS232 Connection
  4. [SOLVED:] Setting Pivot Chart height at pivot table refresh
  5. Macro for hidding and unhidding sheets
  6. Solved: how to copy range and paste in same range in another workbook
  7. Pop Up Message Keeps popping up
  8. [SOLVED:] Application or Object defined error
  9. Solved: populate with range from another sheet
  10. Find the Double ID
  11. Closed workbook and extract sheet by cell value
  12. Solved: msgbox displaying new workbook object path
  13. Conditional formatting according to range
  14. Retreiving the properties out of a class.
  15. fill Combo box data acroding to text box data entry.
  16. Solved: Loop Help
  17. Multiple LIKE operators?
  18. Solved: help getting listindex from listbox
  19. Open Workbook transfer info then close workbook (2007)
  20. [SOLVED:] Many urgent excel at vertical instead of horizontal word
  21. Compare two worksheets and give the difference as result
  22. Input box to select sheet then rename sheet
  23. To get in Excel the URL of the opened Webpage ?
  24. Array raising each element to a power - please help!
  25. [SOLVED:] Split Data in one cell into below rows
  26. Copying and pasting cells from Excel to a fillable PDF file
  27. Sort duplicates on top
  28. Help getting script to exit if cell is blank
  29. Solved: Dynamically setting a dropdown dependant upon cell value
  30. VBA with PI Datalink
  31. Macro doesn’t work after a table is created.
  32. To paste in Word the selected text in webpage by an Excel macro
  33. Adding MMM-YY to filename
  34. Combine multiple rows into one and then seprate specific columns
  35. Solved: VBA Copy a template sheet and paste it into multiple sheets
  36. Something odd has happened with an "Always on Top" window.
  37. [SOLVED:] 3 cells USERFORM to enroll in one cell in excel
  38. Solved: Converting the VB code to VBA.
  39. Total values associated with unique value in adjacent column
  40. VBA HELP! - Need slight change to my code
  41. VBA pivot with no range
  42. Drop Down List to Copy Contents of Another Column into a Certain Column
  43. VBA Help - Desk sharing solution - thanks in advance
  44. How to post sample excel data
  45. Solved: run macro from one workbok to affect other workbook
  46. Solved: code running too fast?
  47. Change Dropdown Macro
  48. Find all hard coded references
  49. Master Directory Search (Needs A Tweak)
  50. VBA from Excel to Outlook 2010 help
  51. Solved: CAGR formula using only range as input
  52. Synchronizing Multiple Worksheets
  53. Solved: function to find the number of iterations/loops Do...Loop
  54. Solved: Dynamically populate combobox in userform
  55. Accessing files in order of Date Last modified
  56. Solved: Loop through multiple sheets and delete rows based on a cell reference
  57. Project locked for viewing - SendKeys?
  58. Excel 2 XML using Macro
  59. Macro is getting Runtime error 91 - why?
  60. Macro Triggers Unreadable Content Error on Restart
  61. Sleeper: Macro loop issues
  62. Solved: Detecting Last Time File Was Opened
  63. Solved: Opening and writing to multiple ASCII text files
  64. find closest date
  65. Solved: Calculate Distribution
  66. Save as xlsm function
  67. Getting Application defined error 1004 for vba
  68. FileSystemObject create file containing text copied from IE
  69. Solved: Stop watch in excel which just displays minutes
  70. Insert and Delete Rows in Entire Workbook
  71. Reference across sheets
  72. Worksheet on change code a bit slow
  73. Can somebody help to achieve following tasks?
  74. Solved: Command Button (Save as PDF)
  75. How to copy an active Excel worksheet to another excel file?
  76. Using conditional formatting
  77. getting the row numbers of visible rows in an filtered selection
  78. simple auto macro :)
  79. Copying sheets into new workbook
  80. How to create a sequence of dates?
  81. VB disable conditional formatting code
  82. [SOLVED:] Determining the 2nd highest number in a list
  83. Solved: update pivot tables based on the value of cell 'C2'
  84. Real Time Clock in a Textbox on a Userform
  85. alphanumerics only
  86. Macro to import entire text file into single cell
  87. Simple Merge of two lists/tables
  88. [SOLVED:] Index/Match VBA equivalent to append data
  89. Solved: How to suppress replacing cells when using PasteSpecial?
  90. Solved: Populate hyphen for continuous three or more zero in a row
  91. [SLEEPER:] vba program
  92. [SOLVED:] Delete Duplicate Values only... Not rows
  93. Solved: Creating a dynamic user defined function
  94. Filter a sheet and copy results to another sheet
  95. date range and return value
  96. Solved: Fill an array with vlookup vba
  97. shade header row
  98. Conditional Formatting - Change font
  99. Paste onto filtered cells
  100. Solved: VBA Interaction with IE
  101. modify macro with hyperlink
  102. Moving Files Based on Last Modified Date
  103. Solved: Creating a dynamic concatenation from a list
  104. What is the code to open access file
  105. Troubleshoot an Overflow Error
  106. Sleeper: Passing transformed arguments to UDF
  107. Solved: Automatically Update date in cell value if workbook is saved under a different name.
  108. MyCheck Fuction
  109. Sumdata based on a table of possible criteria
  110. Solved: error with mouse_down
  111. How to enumerate a variant array?
  112. Excel WB painfully slow
  113. Solved: Error found in codes given in KB
  114. Solved: Copy From Multiple Files To One
  115. Solved: Email active worksheet using Outlook
  116. GOBACK subroutine for Excel 2007
  117. Solved: Identifying Duplicates Prior to Data Entry.
  118. Solved: Copy, Open, Paste
  119. Solved: Add Hairline Border Via Vb
  120. Excel using Loop
  121. Solved: VBA table summarize
  122. Populate Two Text Box using input value
  123. 'Partial' Julian Date Issue
  124. Windows Explorer Shortcut Link Generator
  125. Conditional Format On Specific Range
  126. Filtered Cells Problem
  127. Remove last few characters from a string
  128. xmlHttp get requst - cannot get past login
  129. How to control an Excel file without opening it?
  130. XML Integration
  131. Solved: Locate Date in cell formatted as DD-MMM
  132. FileName
  133. "method range of object _worksheet failed" Error
  134. get data from word form into excel using macro
  135. Solved: creating multiple xltx templates
  136. Formula to pull formula from another cell
  137. Solved: insert row if match is missing in column above
  138. Solved: Populating Textbox 2 on the basis of Textbox 1
  139. MACRO help to delete some files in a particular folder
  140. Login and Password for user form
  141. Create Workbooks based on Unique Values from a Column
  142. Code running amazing slow when file is shared
  143. Loop? Copy/Paste from to Summary from Workbooks on Server
  144. [SOLVED:] Find Question
  145. Search Functionality that moves cursor
  146. Solved: Hide Rows...help in code
  147. Concatenate (Nest) "IF" Commands ??
  148. Syntax for Set_Cursor_Pos()
  149. [SLEEPER:] Search Worksheet for Name if found copy to new workbook
  150. Compare data between two workbooks
  151. Excel code to open Access!
  152. Source workbook keeps opening when Destination workbook is protected?
  153. Need to increase the percentage in a cell containing the original value
  154. Storing Variable From One Cell And Printing It Repetitively In Another Column
  155. Solved: Change color figures, with discretion
  156. Thematic Map
  157. show username if file is open
  158. Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest
  159. Loop through rows and delete/keep
  160. Printing Unique Values (From a column) in a Combobox
  161. Modify Cut Paste
  162. Help with concatrelated vba excel
  163. Printing issue
  164. Solved: cut and pasted into Sheet2
  165. A Combo Box for Certain Types of Information from another worksheet??
  166. Solved: Copy Range If Cell Value Equals
  167. Highlight the last selected cell
  168. Solved: Problem in creating status bar
  169. VBA functionality for String manipulation
  170. use date stamp to trigger Shift:=xlDown?
  171. Calculation On/OFF Basis On Selection
  172. Sum amounts based on another column
  173. [SOLVED:] Select the shape as shape variable
  174. How to solve excel compatibility?
  175. Solved: Do something every 14 minutes
  176. Solved: VBA Formatting mess of text
  177. [SOLVED:] Open Notepad and write something onto it
  178. Passing an Object to a Function
  179. auto save and close workbook after 15 minutes of inactivity
  180. Loop filter and copy
  181. Getting data from Word Controls into Excel
  182. Solved: SumProduct RowsandColumns
  183. Populating IP Address & Username of the user in Excel
  184. Question on ActiveWorkbook.Calculate
  185. Copying range to variant
  186. Solved: Runtime error '13', Type Mismatch
  187. Formatting excel sheet
  188. Disable File Save And Highlight Empty Cells
  189. Solved: automatic FormulaCalculation Option using VBA
  190. Help VBA code for calculating time difference
  191. Solved: vary column
  192. Nested loops and populating a new ws with the items
  193. Merging two or more files, column by column
  194. Compare two worksheet current code modification
  195. auto Email
  196. Data transfer based on certain findings
  197. editing text in a cell
  198. Send Excel Body by Outlook
  199. Excel VBA Error 445 in 2007/10 but 2003 is fine
  200. Same number of trades
  201. Count members of AD group from Excel
  202. Play Sound in Excel
  203. Highlighting particular cells
  204. Solved: Workbook Slowdown
  205. Plotting to PDF
  206. Sort Values In Array
  207. [SOLVED:] File Renaming Tool - Working in Subfolders
  208. Solved: Change in Path to Server - Query Macros Affected
  209. Sine Wave Audio Sound Generator
  210. Solved: Pivot Date Filter between variable number of days
  211. Problem with keeping the year end dates of downloaded financial data
  212. Solved: Locking a Row Question
  213. Nested IF Function not working when the first condition is False
  214. Help please want to write string sorting function
  215. Solved: count, insert, copy, paste rows from one worksheet to another
  216. Application.MacroOptions: StatusBar property not working
  217. Need help on MultiPage control
  218. Solved: Advice and Help which database to use
  219. combine all file in a one workbook
  220. Excel 2007
  221. Read/Write Userform to variable range of cells
  222. Highlight the selected cell
  223. Private Sub : copy formula
  224. Madness - Excel Crashing
  225. If Statement checking
  226. Searching multiple workbooks for hidden content
  227. Solved: Copy B4 value of each guide based on column A of worksheet "Plan2"
  228. Solved: Copy and Paste Row if Cell Has Value
  229. Filter : date after 15 /10/2012
  230. excel pivot table problem
  231. Code doesn't send in email
  232. VBA merge from some open and some closed workbooks
  233. Selecting 2 Cells to the right of the ActiveCell
  234. Copying Excel range to Word doesn't copy the image
  235. Solved: Inserting data into the column and maintain it locked
  236. Scroll to a named macro in the VBE
  237. Solved: Dynamic array in VBA of newly added worksheets
  238. Solved: Vba code to clear data cells only not those with formula
  239. Add value, as seconds, to LongDate
  240. Generating Custom Report thru VBA
  241. Solved: Copy formula automatically & Paste valuse :VBA code error Rectification
  242. vba workbook_sheetchange event for xlam thisworkbook
  243. Run HLOOKUP macro on outcome of Data Validation
  244. Application defined or Object defined error
  245. Choose range
  246. Solved: Track Cell Value Change
  247. 430 Error when Macro Run
  248. [SOLVED:] Operate with data from txt file
  249. Solved: Macro to Re-arrange Data
  250. Create Search Form