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

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